X
XP
Using Office 2007 with Windows XP;
I need a formula that can look across several columns and return the value
of the header row for the column that does not contain a zero value.
For example (hopefully this will line up):
A F G H
R1 MISC1 MISC2 MISC3
R3 {formula} 0 25.25 0
If the example above, the formula in A3 should return: MISC2
Since that is the column heading for the column that doesn't have
a zero balance.
I hope this makes sense. Thanks much for your assistance.
I need a formula that can look across several columns and return the value
of the header row for the column that does not contain a zero value.
For example (hopefully this will line up):
A F G H
R1 MISC1 MISC2 MISC3
R3 {formula} 0 25.25 0
If the example above, the formula in A3 should return: MISC2
Since that is the column heading for the column that doesn't have
a zero balance.
I hope this makes sense. Thanks much for your assistance.