How to find the maximum/minimum value in a column based on month and year?

I am designing a dashboard in Excel 2016.

My spreadsheet has a sheet called "Data" in which I store all data collected from a weather station.

The first column is called "Dates" and contains every date over the last 10 years. The columns next to it contain the raw data from different instruments, sensors: Rain gauge, temperature, wind speed, etc.

On the dashboard I want to create a similar table to what you can find on following website: [login to view URL]

Now the challenge is to find the following data:

-What is the highest/lowest, average reading for instrument A for any given day during the month (1 to 12) over the years?

Say for example the highest temperature recorded was 48.6 degrees C and that happened on 20 February 2009.

So, in the dash I want to see for the month February: The value and the date it happened.

Blank or erroneous cells should be neglected.

I also want to be able to select an instrument, a month and a year from a dropdown list so that I can see the data for any given month.

I hope this will make sense.

This is a hobby project for the local community and funds are limited.

Many thanks in advance!


Kemahiran: Excel, Pemprosesan Data, Perlombongan Data

Lihat lagi: displays grade employees based value column job sql, excel vba sum based value column, how to count by month and year in excel, excel vba filter column based on cell value, how to move a chart to another worksheet in excel 2016, how to create a searchable drop down list in excel 2016, how to add new column with value to the existing datatable in c#, how to split a cell into two rows in excel 2016, how to convert image urls to actual images in excel 2016, how to add a record to a table in excel 2016, how to extract unique values based on criteria in excel, how do you find the maximum or minimum value of a function, how to create a table inside a cell in excel 2016, how to change compatibility mode to normal mode in excel 2016, how do i create a drop down list in excel 2016?, how to find the slope of a trendline in excel 2016, how to categorize text strings based on keywords in excel?, how to find missing numbers in a sequence in excel 2016, how to get more than 65,000 rows in excel 2016

Tentang Majikan:
( 0 ulasan ) St Andrews, Australia

ID Projek: #30548520

Dianugerahkan kepada:


Hi, Greetings! ✅Checked your project details: find the maximum/minimum value in a column ✅Completed Time: 24 hours or your required deadline. Kindly, I work on many projects like your request, I can send you many sa Lagi

$15 AUD dalam sehari
(4 Ulasan)

15 pekerja bebas membida secara purata $25 untuk pekerjaan ini

(429 Ulasan)

Hello, I just read your project description and will be glad to assist you with that on top priority basis. I am an experienced Data Analyst and advance level Excel user. Data Analytics, Automation and Data Visualizati Lagi

$20 AUD dalam sehari
(124 Ulasan)
(28 Ulasan)

Hello, I've read your project requirements thoroughly. It's quite an easy task and I can achieve this through a VBA script. It will be quick and accurate. I will start immediately and complete it within a few hours. I Lagi

$30 AUD dalam sehari
(25 Ulasan)
(4 Ulasan)

Hi, Luke. I'm a Reporting Analyst and it's my day to day job to deliver reports similar to what you are looking for. I will be able to help you with your request.

$20 AUD dalam sehari
(1 Ulasan)

Hi There, I’m a data analyst having six years of extensive experience with R language, Tableau, Power BI, Excel, Mysql and can deliver your task efficiently in minimal timeframe. Please drop me a text for further disc Lagi

$20 AUD dalam sehari
(1 Ulasan)

MY WORK IS MY STRENGTH . I HACE CONFIDENCE ON MYSELF .THIS IS MY STRENGTH . If you award me the project I'd be very happy to discuss this further and get started for you as soon as possible.

$20 AUD dalam 7 hari
(0 Ulasan)

I am Karunarathna from Sri Lanka. I am a newcomer to the freelancer. But I have good IT knowledge. I was inspired opportunity in freelancer internet job. I have completed Sri Lanka Computer Driving Silence course. I ha Lagi

$40 AUD dalam sehari
(0 Ulasan)

I have experience with engineering data processing. I believe I can deliver the dashboard that you described.

$20 AUD dalam 7 hari
(0 Ulasan)

Hello there! I am a computer engineer, who is very hard working and organized on finishing the task with an affordable bid amount as early as possible. You can also check my description.

$20 AUD dalam 7 hari
(0 Ulasan)

Hello Sir, I am an excel expert with more than 10 years of experience. I will edit your file very simply you can check all the required prior information just in one click. I can do it right now in minimum time.

$10 AUD dalam sehari
(0 Ulasan)

Hi, there. I have read your project description very carefully so I had confidence that I can do it. I am sure that I can complete your project with in less time frame than other freelancers. I have experience over 3 y Lagi

$20 AUD dalam 7 hari
(0 Ulasan)

I can provide you an Excel sheet linked to your data source, enabling yo to filter the data through visual Slicer and developing any filtering condition you need. Through slicers and timelines you can check any measure Lagi

$10 AUD dalam 2 hari
(0 Ulasan)