I'm using the following formula to scan a dataset for the minimum temperature recorded for each year. There are some gaps in the data where there is nothing available for a given year, such as 1895, 1910 ect. When I use this forumla excel returns a zero for these instances, but I need to be able to differentiate between a true zero and simply a case where the year was not found. I've tried ISBLANK and I'm still having the same problem.
=MIN(IF(D:D = 1893 + ROW(A4), IF(E:E = 3,G:G )))
Any help appreciated!
Bookmarks