S
Sushil Patil
Hello,
I have worksheet like one below
No Att1 Att2 Att3 Att4 Att5
A 1 1 1
B 1 1 1 1
C 1 1
D 1 1
E 1 1 1
F 1 1 1 1
I want to know a formula that will return column header for second non empty cell in a row.
fo ex. for A formula should return Att3
Also if you can tell about how to modify formula so as that it will return column header for nth non empty cell in row.
Thanks and Regards
SushiL
Submitted via EggHeadCafe - Software Developer Portal of Choice
CommandEventArgs (or- Which Button was Clicked?)
http://www.eggheadcafe.com/tutorial...67f-521cc319a78e/commandeventargs-or-whi.aspx
I have worksheet like one below
No Att1 Att2 Att3 Att4 Att5
A 1 1 1
B 1 1 1 1
C 1 1
D 1 1
E 1 1 1
F 1 1 1 1
I want to know a formula that will return column header for second non empty cell in a row.
fo ex. for A formula should return Att3
Also if you can tell about how to modify formula so as that it will return column header for nth non empty cell in row.
Thanks and Regards
SushiL
Submitted via EggHeadCafe - Software Developer Portal of Choice
CommandEventArgs (or- Which Button was Clicked?)
http://www.eggheadcafe.com/tutorial...67f-521cc319a78e/commandeventargs-or-whi.aspx