Thread
:
Formula to find last value in a range & then offset
View Single Post
#
5
Posted to microsoft.public.excel.worksheet.functions
[email protected]
external usenet poster
Posts: 2
Formula to find last value in a range & then offset
Thanks for your help but I've found the answer its:
=OFFSET(INDEX($P168:$AA168,COUNTA($P168:$AA168)),0 ,-12)
Quite simple thinking about it
Pete
Reply With Quote
[email protected]
View Public Profile
Find all posts by
[email protected]
Formula to find last value in a range & then offset