Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
display last entry into a cell automatically
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
automatically prefix cell entry with leading zeros | Excel Worksheet Functions | |||
Automatically prefix cell entry | Excel Worksheet Functions | |||
Link cell between WS w/o dest display 0-jan if no entry at source | Excel Worksheet Functions | |||
automatically add borders to a cell after entry is complete | Excel Discussion (Misc queries) | |||
How do i have a check display with any data entry in a cell | Excel Discussion (Misc queries) |