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!
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 Daha Fazla
Bu iş için 15 freelancer ortalamada $25 teklif veriyor
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 Daha Fazla
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 Daha Fazla
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.
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 Daha Fazla
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.
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 Daha Fazla
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.
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.