Thread
:
display last entry into a cell automatically
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
xlmate
external usenet poster
Posts: 144
display last entry into a cell automatically
try
= LOOKUP(1E+30,B:B)
--
Hope this is helpful
Appreciate that you provide your feedback by clicking the Yes button below
if this post have helped you.
Thank You
cheers, francis
"mike CBA" wrote:
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
xlmate
View Public Profile
Find all posts by xlmate