Thread: Offset formula
View Single Post
  #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.