I am trying to sort several thousand rows of weather data. Each row represents a date (col. C, DATE) and the only other column I am concerned with is the precipitation level (col. D, PRCP.)
My goal is to find the date within the calendar year that is most consistently not rainy.
The date is in the 8 character format (i.e. 19800111 = Jan. 11, 1980) and I would need to count the calendar date while ignoring the first four digits (year) if the PRCP column (D) is 0. This (I am assuming) would keep a tally for that date's number of dry days. At the end of the function, the day with the highest count would be the historically driest day of the year.
Does that make sense? Is there a better way to approach? How would this be scripted?
Attached a screenshot of the csv columns. I am in Excel for Mac v 15.25 Thanks for any insight!