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.
|