Hi,
I'm looking for a formula that will return the column header (a date) of the first instance of a number greater than 0.
For example if columns A through S had dates as in row 1 (header row), and in row 2, every column contained a 0 up until column P, I would want the date (Row 1, Column P) returned? I think this might be a sort of index/match formula, but I am not very familiar with these.
Appreciate your help.
Jason![]()
Bookmarks