LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
richy
 
Posts: n/a
Default Offset formula

Hello all, hoping someone can help with a formulae dilema.
I have a table with target information set in rows, and a destination
group of cells that call for the information to be picked from the rows
and put in offset boxes, i.e when pasting the formulae first created
the formula is adding a 3 cell variance from the wanted destination
cells, because the destination cells are 3 cells apart from being
concurrent.

Can anyone suggest a formula that will solve the problem.

Thanks Richard.

 
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
Is it possible? DakotaNJ Excel Worksheet Functions 25 September 18th 06 09:30 PM
Match then lookup Tenacity Excel Worksheet Functions 9 December 3rd 05 05:30 AM
Formula Problem - interrupted by #VALUE! in other cells!? Ted Excel Worksheet Functions 17 November 25th 05 05:18 PM
adding row to forumla carrera Excel Discussion (Misc queries) 9 August 23rd 05 10:24 PM
improve formula offset and indirect John Contact Excel Worksheet Functions 1 June 17th 05 07:28 AM


All times are GMT +1. The time now is 04:27 AM.

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

About Us

"It's about Microsoft Excel"