| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find last non-blank row with a worksheet function
Find the last row with a value.
Say I have a worksheet with a data entery range of A1 to A100. The user is required to enter data from row 1 downwards and cannot leave blanks between rows. I want to return the value in the last comleted row by function. Any ideas? For example that last row with a value may be in cell A20 of the A1:A100 range. Rgds, Bruce |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a worksheet function that will... | Excel Worksheet Functions | |||
| Changing worksheet cells from within a function | Setting up and Configuration of Excel | |||
| Evaluating Today() function only once in a worksheet | Excel Worksheet Functions | |||
| What function would let me find Batting Averages? | Excel Worksheet Functions | |||
| how do you do a sumif function on more than one worksheet? | Excel Worksheet Functions | |||
Threaded Mode
