View Single Post
  #1   Report Post  
Ravi
 
Posts: n/a
Default A SIMPLER FORMULA TO GET A REFERENCE OF WHICH COLUMN IS POPULATED

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