Geek Answers Handbook

Formula to find header index of first non empty range cell in Excel?

I have this table, which can be considered as a basic custom gantt diagram:

table 1

And I would like to populate column A with start dates based on the first cell in the range on the same row and the header value of the corresponding column (row 1). It’s easier to show my expected result than to actually write it:

enter image description here

Many thanks for your help!

+4
source share
1 answer

In A2, try copying this formula down

=IF(COUNTA(B2:Z2),INDEX(B$1:Z$1,MATCH(TRUE,INDEX(B2:Z2<>"",0),0)),"")

you may need to format column A with the desired date format

receives data up to column Z, adjusts if necessary

+8
source

More articles:


All Articles