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
|