.. know which column is populated ..

If only a single cell within I15:O15 would be populated at any time,
then this might suffice:

=IF(ISNA(MATCH(TRUE,I15:O15<"",0)),"",MATCH(TRUE, I15:O15<"",0)+8)

Formula to be array-entered, i.e. press CTRL+SHIFT+ENTER
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Ravi" wrote in message
...
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