Thread
:
display last entry into a cell automatically
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
display last entry into a cell automatically
One way where 999999 is any number larger than possible in the column
=LOOKUP(999999,b:b)
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"mike CBA" wrote in message
...
how do i automatically display the last entry of a cell into a specified
cell. for example: A1 is the specified cell and the last entries will be
on
column B. If today the last entry is 5, A1 will be 5. if tomorrow the last
entry will be 10, A1 wil be 10. The entries in column B is continuing.
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett