| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I display the last entry in a list
In Excel 2003, I have a list of values in a column and want to return the
last entry (ie highest row number) in the list to another cell. Can this be done? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I display the last entry in a list
Hi,
This does it for column A =INDIRECT("A"&SUMPRODUCT(MAX((ROW(A1:A65535))*(A1: A65535<"")))) Mike "ozsteve" wrote: In Excel 2003, I have a list of values in a column and want to return the last entry (ie highest row number) in the list to another cell. Can this be done? |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I display the last entry in a list
Hi Mike
Thanks for the reply. I'm sure if understood it I could get this to work, but Gary's response below works a treat out of the box and suits my needs. Thanks for your input. Steve O "Mike H" wrote: Hi, This does it for column A =INDIRECT("A"&SUMPRODUCT(MAX((ROW(A1:A65535))*(A1: A65535<"")))) Mike "ozsteve" wrote: In Excel 2003, I have a list of values in a column and want to return the last entry (ie highest row number) in the list to another cell. Can this be done? |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I display the last entry in a list
=LOOKUP(99^99,A:A)
for column A -- Gary''s Student - gsnu200759 "ozsteve" wrote: In Excel 2003, I have a list of values in a column and want to return the last entry (ie highest row number) in the list to another cell. Can this be done? |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I display the last entry in a list
Hi Gary,
Thanks for the quick reply. that does the trick perfectly. Steve O "Gary''s Student" wrote: =LOOKUP(99^99,A:A) for column A -- Gary''s Student - gsnu200759 "ozsteve" wrote: In Excel 2003, I have a list of values in a column and want to return the last entry (ie highest row number) in the list to another cell. Can this be done? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| drop down list shows first blank row after last list entry | Excel Discussion (Misc queries) | |||
| How do i have a check display with any data entry in a cell | Excel Discussion (Misc queries) | |||
| Display Last Entry in Excel | Excel Worksheet Functions | |||
| display Calendar for Excel field entry? | Excel Worksheet Functions | |||
| display last entry in Excel | Charts and Charting in Excel | |||
Hybrid Mode
