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