Home |
Search |
Today's Posts |
#1
|
|||
|
|||
latest entry
How do I get the last entry in a fixed column? For example: The column is 10 rows. Row 1 is the number 25 Row 2 is 30 The rest are blanks. What is the function to pick the latest entry that being 30. Then when row 3 changes to 45 then the "choose" function would select the latest entry that now being 45. Thanks Bill Andrus -- billandrus ------------------------------------------------------------------------ billandrus's Profile: http://www.excelforum.com/member.php...o&userid=27945 View this thread: http://www.excelforum.com/showthread...hreadid=478927 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
data entry form Excel | Excel Discussion (Misc queries) | |||
search for latest date | Excel Worksheet Functions | |||
limit text entry in a range of cells | Excel Discussion (Misc queries) | |||
Data Validation / Cell Entry | Excel Discussion (Misc queries) | |||
Move the last entry in a column to a different cell, when the loc. | Excel Worksheet Functions |