display last entry into a cell automatically

  • Thread starter Thread starter mike CBA
  • Start date Start date
M

mike CBA

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.
 
One way where 999999 is any number larger than possible in the column

=LOOKUP(999999,b:b)
 
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
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top