Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I find the last row containing data in a spreadsheet
I have a spreadsheet which can contain between 1500 and 3000 rows of data and
I want to be able to find the first blank row. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I find the last row containing data in a spreadsheet
See if one of these works for you:
Note: Commit these array formulas by holding down [Ctrl] and [Shift] when you press [Enter] 1. The address of the first empty cell in Col_A: =CELL("address",INDEX(A1:A65535,MATCH(TRUE,ISBLANK (A1:A65535),0))) 2. A reference to the first empty cell in Col_A: =INDEX(A1:A65535,MATCH(TRUE,ISBLANK(A1:A65535),0)) 3. The row number of the first empty cell in Col_A: =MATCH(TRUE,ISBLANK(A1:A65535),0) Does that help? *********** Regards, Ron XL2002, WinXP-Pro "alx613" wrote: I have a spreadsheet which can contain between 1500 and 3000 rows of data and I want to be able to find the first blank row. Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I find the last row containing data in a spreadsheet
What do you mean by 'find'? Do you mean use the row # in a formula, or
identify within a macro so you can place data there, or quickly navigate there, or something else entirely? "alx613" wrote: I have a spreadsheet which can contain between 1500 and 3000 rows of data and I want to be able to find the first blank row. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Finding repeated data in a excel spreadsheet | Excel Discussion (Misc queries) | |||
UserForm Data to Spreadsheet | Excel Discussion (Misc queries) | |||
Entering data on template and then data going to a spreadsheet. | Excel Discussion (Misc queries) | |||
Another question on how to find duplicate data | Excel Worksheet Functions |