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
=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? |
#4
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? |
#5
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? |
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 |