Thanks, That's great.

This formula works. Just 1 issue I'm getting which is it also picking up
columns with Zeros' (this is a result of a formula) . I wanted to extract
only the positive values. Is there another tweak to it that I need to make.


"Aladin Akyurek" wrote:

=MATCH(9.99999999999999E+307,I15:IV15)+COLUMN(I15)-1

Ravi wrote:
Hi, need help on for a simpler formula is available if available. The
problem is I have a spreadsheet with many columns and I would like to know
which column is populated, for the moment I'm using the following :

=IF(I150,COLUMN(I15),"")&IF(J150,COLUMN(J15),"") &IF(K150,COLUMN(K15),"")&IF(M150,COLUMN(M15),"") &IF(N150,COLUMN(N15),"")&IF(O150,COLUMN(O15), "")

The values can only be positive.
A simpler version would be appreciated.
Thanks

--

[1] The SumProduct function should implicitly coerce the truth values to
their Excel numeric equivalents.
[2] The lookup functions should have an optional argument for the return
value, defaulting to #N/A in its absence.