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!


Skills: Excel, Data Processing, Data Mining

See more: 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

About the Employer:
( 0 reviews ) St Andrews, Australia

Project ID: #30548520

Awarded to:


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 More

$15 AUD in 1 day
(4 Reviews)

15 freelancers are bidding on average $25 for this job

(429 Reviews)

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 More

$20 AUD in 1 day
(124 Reviews)
(28 Reviews)

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 More

$30 AUD in 1 day
(25 Reviews)
(4 Reviews)

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 in 1 day
(1 Review)

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 More

$20 AUD in 1 day
(1 Review)

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 in 7 days
(0 Reviews)

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 More

$40 AUD in 1 day
(0 Reviews)

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

$20 AUD in 7 days
(0 Reviews)

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 in 7 days
(0 Reviews)

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 in 1 day
(0 Reviews)

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 More

$20 AUD in 7 days
(0 Reviews)

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 More

$10 AUD in 2 days
(0 Reviews)