View Single Post
  #1   Report Post  
TeddyTash TeddyTash is offline
Junior Member
 
Posts: 15
Question 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