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

Færdiggjort Opslået 2 år siden Betalt ved levering
Færdiggjort Betalt ved levering

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!

Luke

Excel Databehandling Datasøgning

Projekt ID: #30548520

Om projektet

14 bud Remote projekt Aktiv 2 år siden

Tildelt til:

Blackeagle8

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 Flere

$15 AUD på 1 dag
(6 bedømmelser)
2.1

14 freelancere byder i gennemsnit $24 timen for dette job

daniyal3214

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 Flere

$20 AUD på 1 dag
(138 bedømmelser)
6.9
MonisZafar

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 Flere

$30 AUD på 1 dag
(25 bedømmelser)
4.9
mitzar713

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 på 1 dag
(1 bedømmelse)
1.9
JagmitMaan

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 Flere

$20 AUD på 1 dag
(1 bedømmelse)
0.0
aroprakashpanda8

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 dage
(0 bedømmelser)
0.0
SandrinRodrigo

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

$20 AUD in 7 dage
(0 bedømmelser)
0.0
kevinarizobal

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 dage
(0 bedømmelser)
0.0
Raziiiii

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 på 1 dag
(0 bedømmelser)
0.0
sagargupta1796

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 Flere

$20 AUD in 7 dage
(0 bedømmelser)
0.0
Gancedoconsultor

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 Flere

$10 AUD in 2 dage
(0 bedømmelser)
0.0