To find first non blank cell in a row then return column header

[divi123]

I have this table, which can be seen as a basic custom gantt chart:
KLRWo.png


And I would like to fill the A column with start dates, based on the first filled cell of the range on the same row, and the header value of its respective column (row 1). It's easier to show my expected result than write it actually:

WiMZH.png

Thanks very much for your help!

[hemesh]

can you please upload a book !

[alvin-chung]

Hi divi123, perhaps this?

Please Login or Register  to view this content.

_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin

[hemesh]

Hello DV ! You could use below
copy and paste in A3
=IFERROR(INDEX(B$2:P$2,SMALL(IF($B4:$P4<>"",COLUMN($B4:$P4)-COLUMN($B$3)+1),1)),"") then hold control and shift key together then press Enter now release all three keys , and drag down !

[divi123]

A similar and simple way was suggested and it perfectly works well.. could some one help me explaining it

=IF(COUNTA(B4:G4),INDEX(B$2:G$2,MATCH(TRUE,INDEX(B4:G4<>"",0),0)),"")

[divi123]

Even ths suits well

IF(ISNA(INDEX(B$2:G$2,MATCH(TRUE,INDEX(B6:G6<>"",0),0))),"",INDEX(B$2:G$2,MATCH(TRUE,INDEX(B6:G6<>"",0),0)))

Thanks guys !!

[alvin-chung]

You're welcome, generally these solutions looked for non-empty cells and return the first match if found, else it'll return an empty string



_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin

[Ronnieooi]

Hi,
how do we find the reverse. Example the last non blank cell in a row then return the column header

[AliGW]

Administrative Note:

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread