First time here. I'm new to excel, so this will probably be very simple for most of you, but I have been trying to find an answer for hours. Any help would be much appreciated!
I need to know the value (which is a date) of the first non-blank cell in a range in a row. I have found some array formulas by searching forums/google etc., but they either return it for the whole row (which I don't want), or they return text (which I don't want), or they don't work at all.
The range is: B9:FL9. Some of the cells in this range are blank, some are "0", and some contain dates. I need to know the most recent (furthest left) cell that contains a date and what that date is. Thanks!
Bookmarks