| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locate last cell in column
I need to find the row number of the last cell in column A:A. Column A:A
contains many gaps, and the data is a mixture of dates and text. For Example: The formula should return 10 for the following data. 1/21/2006 David Sam Paul 2/5/2008 Fred David |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to locate a cell | Excel Discussion (Misc queries) | |||
| Locate a specific row or column | New Users to Excel | |||
| How to locate the Row and Column of an Active Cell | Excel Discussion (Misc queries) | |||
| Locate a cell, based on a criteria, then use the 'Cell' command... | Excel Discussion (Misc queries) | |||
| Locate max value of one column based on criteria in another colum | Excel Worksheet Functions | |||
Threaded Mode
