First Non-Blank Cell in row - returning the column header

Hi all,

I'm wondering if there is a way to do the following in Excel. I've attached a sample dataset.

My data is:

Column A I have a list of tasks that run
Row 1 (headers) I have the date the tasks are run (I must have latest date on the left)
I log the volume of times each task runs per day in Cells B2 and onwards

E.g. Row 2 is Task 1 and Column B is 02/02/2020. On this date Task 1 ran 13 times so in B2 I'd log the value as 13. I leave cells where the task wasn't run at all as blank

What I want to include underneath this table is a list of all the Tasks and include the date the task was last run i.e. the date the task row had a non-blank value.

Can this be done with formulas at all? I'd be massively grateful for help.

Cheers

Try this in B16:

=INDEX($B$1:$G$1,MATCH(TRUE,INDEX(INDEX($B$2:$G$11,MATCH(A16,$A$2:$A$11,0),0)<>"",0),0))

Enter an array formula in cell B16, then drag down

Formula:

Please Login or Register  to view this content.