Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
oFFSET
Hi Jaime,
Am Wed, 13 Jan 2016 11:38:56 -0800 (PST) schrieb : 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 your explanation is not really clear but I hope I understood it correctly. Try: =INDIRECT("J"&MATCH("*"&"(60C)",B:B,-1)+5) Regards Claus B. -- Vista Ultimate / Windows7 Office 2007 Ultimate / 2010 Professional |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Application.Union(c.Offset(0, 1), c.Offset(0, 2)... to a list onsame & another sheet | Excel Programming | |||
Take active cell value in for loop and offset based on another cellvalue for columns to offset | Excel Programming | |||
Compare Cell Values, Offset(-1,0), Offset(-1,-1), and xlFillDefaul | Excel Worksheet Functions | |||
Compare Cell Values, Offset(-1,0), Offset(-1,-1), and xlFillDefaul | Excel Programming | |||
Find, Copy offset to offset on other sheet, Run-time 1004. | Excel Programming |