| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding Latest Variable
Assume cells A1 to A20 are filled in one at a time with values every 5
minutes. A1 will have a value after 5 minutes, A2 will have a value after 10 minutes, A3 after 15 minutes etc ... I would like cell A21 to indicate the most recent added value. For example, after 12 minutes I would like A21 to equal A2, after 17 minutes equal to A3 etc ... What formula do I place in cell A21 to do this? -- Ken |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Finding Latest Variable
Ken
maybe: =IF(ISERROR(INDEX(A1:A20,COUNTA(A1:A20))),"",INDEX (A1:A20,COUNTA(A1:A20))) Regards Trevor "Ken" wrote in message ... Assume cells A1 to A20 are filled in one at a time with values every 5 minutes. A1 will have a value after 5 minutes, A2 will have a value after 10 minutes, A3 after 15 minutes etc ... I would like cell A21 to indicate the most recent added value. For example, after 12 minutes I would like A21 to equal A2, after 17 minutes equal to A3 etc ... What formula do I place in cell A21 to do this? -- Ken |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding the latest date represented in a group of cells | Excel Discussion (Misc queries) | |||
| Finding max array value of variable cell range | Excel Discussion (Misc queries) | |||
| Finding the Latest Date from Several Dates in Different Columns | Excel Discussion (Misc queries) | |||
| why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel? | Excel Worksheet Functions | |||
| Finding intersection of row and column (both variable) in table | Excel Worksheet Functions | |||
Hybrid Mode
