| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how to find blank cell in column
ex
in column a a1=1 a2=2 a3=3 a4=4 a5=blank which formula for finding blank cell (a5) thanks in advance |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
how to find blank cell in column
Array* formula for finding first blank cell in a range:
=ADDRESS(MIN(IF(ISBLANK(A1:A100),ROW(A1:A100),"x") ),COLUMN($A$1),4) Adjust ranges as needed *Use Ctrl+Shift+Enter to confirm array function -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "vinod" wrote: ex in column a a1=1 a2=2 a3=3 a4=4 a5=blank which formula for finding blank cell (a5) thanks in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maddening Dilemma - Compare each cell within column a to each cell in column b and find unique matches | Excel Worksheet Functions | |||
| Trying to find the fourth blank cell in a column | Excel Discussion (Misc queries) | |||
| Find First Non blank cell than find column header and return that value | Excel Worksheet Functions | |||
| Find 1st blank cell in column & sum to the same row in another col | Excel Worksheet Functions | |||
| Find first non-blank or non-zero in a column of data | Excel Discussion (Misc queries) | |||
Linear Mode
