| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cell reference in a formula is called | Excel Discussion (Misc queries) | |||
| Using a formula to create named range reference | Excel Worksheet Functions | |||
| reference a repeating cell in a formula | Excel Worksheet Functions | |||
| formula to return the value of a cell based on a looked up true reference | Excel Worksheet Functions | |||
| Look Up and Cell Reference - Formula Help Needed | Excel Worksheet Functions | |||
Threaded Mode
