Thread
:
Display next to last results
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
Luke
external usenet poster
Posts: 142
Display next to last results
This formula works great to find the last entry in a col.
=LOOKUP(99^99,Sheet1!A:A)
Is there a way to get the formula to show the 2nd to the last entry?
Thank you for all you do,
Luke
Reply With Quote
Luke
View Public Profile
Find all posts by Luke
Display next to last results