Rick, regarding your famous equation...

Code:
=LOOKUP(2,1/(CG5:CG1540<>""),CG5:CG1540)
How can i modify it to tell me what the second and third to the last items are in the given column?

Steve