Good Morning Folk
I have a list of numbers in column A which is constantly expanding down. Haw can I get cell J2 to show the last number entered...
many thanks for your help
Good Morning Folk
I have a list of numbers in column A which is constantly expanding down. Haw can I get cell J2 to show the last number entered...
many thanks for your help
Last edited by JamesT1; 05-13-2011 at 07:04 AM.
This will find the last number in column A
=LOOKUP(9.999999E+307,A:A)
Dave,, many thanks for your help,,, works a treat,,,
Jim
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks