I have a spreadsheet where I track employees weekly hours. I need to find a formula that will return the last date any hours have been recorded. I have the dates for each week listed in Row 1, and then employees listed in rows 2-400. Any help?
It would seem to me that the easiest way would be to enter a helper row, let's say in Row 6, that will have the following formula in each cell: =(COUNT(O14:O33)>0) * (COLUMN() - X) where X equals 1 less than the first column used. So, in our case, where we're starting from Column O, we'd use =(COUNT(O14:O33)>0) * (COLUMN() - 14)
This will give the column only if there are numbers entered.
Then you can use: =INDEX(O5:Z5, MAX(O6:Z6)) to get your answer.
Don't enter "X", I just meant it as a variable. Use a number which is 1 less than the first column you're using. For example, if your first column is O (O = 15), then you'll use 14. If your first column is A, then this whole adjustment will be unnecessary, and you can just use: =(COUNT(A14:A33)>0) * COLUMN() and drag across.