Cell References

D

DOUG ECKERT

I have a formula with a long string of cell references - ("AVERAGE" this long
string of cell references"). I want to copy the cell references one column
space to the right and instruct it to use the same set of references, only
one column space to the right of each original cell reference. For example,
series B3,G3,L3, etc. would become series C3, H3, M3, etc. The OFFSET
function in help is similiar but not the same as what I want to do here.
 
F

FSt1

hi
change your cell references from reletive to absolute ie
from A1 to $A$1.
this way they will keep the origional reference.

Regards
FSt1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Retrospective Cell Naming 2
How do I average a row of 13 enries using the 8 highest in value. 2
A More efficient way to have a function with multiple SUMIF functions. 2
automatically show cell references of formulas 2
Sumproduct Across A Row 11
Local references 4
Cell Referencing 2
Cell references are acting absolute 3

Top