I want to set a formula that will show a header of a non-blank cell in a row. The example is
VjT6YG7.jpg
The formula in column H should show a correct name:
RhSy7M1.jpg
What will the formula be?
I want to set a formula that will show a header of a non-blank cell in a row. The example is
VjT6YG7.jpg
The formula in column H should show a correct name:
RhSy7M1.jpg
What will the formula be?
Hi buhaj47
This formula will work as long as there is only 1 "d" in the row:
Paste it in to H3 and you can drag it down to fill the other rows.Please Login or Register to view this content.
=IFERROR(INDEX($B$2:$G$2,MATCH(1,INDEX(($B3:$G3<>"")*1,0),0)),"")
try this and copy towards down
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks