Thread: oFFSET
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] jaime.calderon816@gmail.com is offline
external usenet poster
 
Posts: 18
Default oFFSET

Help,
I have a huge spreadsheet exported from a different source into excel.

Column B
Example:
Col B Col J
57 (60C) 5
61 (60C) 3
62 (60C) 2
63 (60C) 2
70 (60C) 4

Every time after the last 60C on column b there a "Service Area Total" word
5 Rows below that and the total that I need is on col j or 9 col over to the right

My question is
is there a way for a formula to find the last 60C Go down 5 rows and give the number on column J or 9 columns to the right??

Thank you hope this makes sense.