| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding 2nd last entry
I am using the formula =LOOKUP(2,1/(1-isblank(b10:b65536)),b10:b65536) to
return the last entry in column b, and this works perfectly well, however, I need to also use the 2nd last entry, anyone any ideas |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding the last entry in a column based on criteria | Excel Worksheet Functions | |||
| Finding the first and last entry in a column | Excel Worksheet Functions | |||
| finding an entry from two criteria. | Excel Worksheet Functions | |||
| finding duplicate entry | New Users to Excel | |||
| Finding last entry in column | Excel Worksheet Functions | |||
Threaded Mode
