| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Second last number in list
Steve asked previously
How to find the last number on a list that varies in size: The solution he was given was =LOOKUP(99^99,A:A) Which works perfectly. Now.... is it possible to find the second last number? Thanks in advance, Teddy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I count the number of repeats in a list of data? | Excel Discussion (Misc queries) | |||
| Select every 10th number in a list | Excel Discussion (Misc queries) | |||
| Lookup in a list of number with a headline | Excel Discussion (Misc queries) | |||
| Finding the 3rd largest number in a list | Excel Worksheet Functions | |||
| How to find the second most frequent number in a list? | Excel Worksheet Functions | |||
Threaded Mode
