#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy Application.Union(c.Offset(0, 1), c.Offset(0, 2)... to a list onsame & another sheet Howard Excel Programming 27 September 29th 13 09:20 PM
Take active cell value in for loop and offset based on another cellvalue for columns to offset burl_h Excel Programming 0 May 23rd 12 03:20 AM
Compare Cell Values, Offset(-1,0), Offset(-1,-1), and xlFillDefaul RyGuy Excel Worksheet Functions 2 September 28th 07 10:54 PM
Compare Cell Values, Offset(-1,0), Offset(-1,-1), and xlFillDefaul RyGuy Excel Programming 4 September 28th 07 09:59 PM
Find, Copy offset to offset on other sheet, Run-time 1004. Finny[_3_] Excel Programming 10 December 8th 06 12:46 AM


All times are GMT +1. The time now is 12:28 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"