| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
function to retrive last entry in a column
How to retrive the last entry in a series of rows in a column.
|
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
function to retrive last entry in a column
One way ...
=OFFSET(A1,COUNTA(A:A)-1,) This should give you the value of the last cell in column A. Rgds, ScottO "rsanandkumar" wrote in message ... | How to retrive the last entry in a series of rows in a column. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Format as a MACRO | Excel Worksheet Functions | |||
| IF/AND/OR/DATEIF Issue...sorry...long post... | Excel Worksheet Functions | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| How to replace column letter in refferences with a function using the old column letter? | Links and Linking in Excel | |||
| Move the last entry in a column to a different cell, when the loc. | Excel Worksheet Functions | |||
Hybrid Mode
