Hi all
Im a new convert to excel and have built quite a nice spreadsheet for collating all of the work I am doing but I seem to be struggling on one last thing.
I need a formula that shows the minimum date from a column that isnt a 0, blank or 00/01/1900
=MIN(IF(CB7:CB3076>0,CB7:CB3076)) just doesnt work.
Does anyone have any advice?
Bookmarks