After some time of trying to do the tasks that you require, I was able to solve the problem using pivot tables.
In this case, the MAX or the highest FFDI value in every DAY is reported and this is done in every month and in every year.
Here is the download link:http://wikisend.com/download/292736/Benalls_Shadford_St_data_rev1.xlsx
In that first file, the highest FFDI is calculated all days, all months in all years.
In this second file below, I generated a different layout but I decided to extract all reports PER YEAR. This is just an option depending on how this can help your actual work.
File 2 below:http://wikisend.com/download/594228/Benalls_Shadford_St_data_rev2.xlsx
I hope this helped. If you need assistance in the future, you can request me any time. Or you can simply post a new question saying "For jessmagz"
so that I can assist you as soon as possible.
Please remember to rate my service positively (3-5 stars/faces)
once you have all the
information you need. Tips
are always highly appreciated!
If you have any other questions,please ask me or reply to me
– I’ll be happy to respond.