=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(I15>0,COLUMN(I15),"")&IF(J15>0,COLUMN(J15),"")&IF(K15>0,COLUMN(K15),"")&IF(M15>0,COLUMN(M15),"")&IF(N15>0,COLUMN(N15),"")&IF(O15>0,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.
Bookmarks