Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there an excel funtion that retreives the last cell of a list
Is there an excel funtion that retreives the last cell of a list that
contains data. And then one that will find the next to the last, etc. The list, or series kees getting longer but I always want to link a cell in a table to the last data of the list, at the end of the list. With the offset function it can be done but I was wondering if there was a better function. version: excel 2003 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there an excel funtion that retreives the last cell of a list
See this:
http://xldynamic.com/source/xld.LastValue.html Biff "Bumblebee" wrote in message ... Is there an excel funtion that retreives the last cell of a list that contains data. And then one that will find the next to the last, etc. The list, or series kees getting longer but I always want to link a cell in a table to the last data of the list, at the end of the list. With the offset function it can be done but I was wondering if there was a better function. version: excel 2003 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there an excel funtion that retreives the last cell of a list
Since you are on Excel 2003, convert the data area of interest into a
list by means of Data|List|Create List. Example: Item 7 8 9 75 The area to convert is A1:A5. In order to link to the last cell, invoke: =INDEX(A2:A5,ROWS(A2:A5)) When new records are added to the list, the formula adjusts itself automatically. Bumblebee wrote: Is there an excel funtion that retreives the last cell of a list that contains data. And then one that will find the next to the last, etc. The list, or series kees getting longer but I always want to link a cell in a table to the last data of the list, at the end of the list. With the offset function it can be done but I was wondering if there was a better function. version: excel 2003 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
missing cell borders in Excel | Excel Discussion (Misc queries) | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Possible Lookup Table | Excel Worksheet Functions |