| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Finding the first blank or zero value
Hi
I am trying to find a way to locate which column the first blank or zero value appears in my worksheet. Eg. 1 2 3 4 5 10 11 13 The result should be column 4. I have tried to use lookup with isblank together without success. Any help will be appreciated. Thanks |
|
#2
|
|||
|
|||
|
This will find first blank cell
=MATCH(TRUE,A2:M2="",0) enter with ctrl + shift & enter -- Regards, Peo Sjoblom (No private emails please) "AAMIFC" wrote in message ... Hi I am trying to find a way to locate which column the first blank or zero value appears in my worksheet. Eg. 1 2 3 4 5 10 11 13 The result should be column 4. I have tried to use lookup with isblank together without success. Any help will be appreciated. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting blank and filled cells within a range. | Excel Discussion (Misc queries) | |||
| How to delete blank rows | Excel Discussion (Misc queries) | |||
| blank cells | Excel Discussion (Misc queries) | |||
| Blank Cells in Pivot Tables | Excel Discussion (Misc queries) | |||
| VLOOKUP, OFFSET, MATCH PROBLEM, HELP? | Excel Worksheet Functions | |||
Linear Mode
