E
ExcelMania
Folks,
Pl help me with this simple issue--
For a range of cells in a worksheet- I need to take values from other cells
on the same worksheet but located at a known relative position.
eg: Value in a cell = value in the cell 4 columns to it's right.
I tried =(COLUMN()-4)ROW()
but got an error. Seems straightforward but how can i do it? I need the
relative position as this has to be done on several parts of the worksheet
and a formula with variables would be easier.
Pl help me with this simple issue--
For a range of cells in a worksheet- I need to take values from other cells
on the same worksheet but located at a known relative position.
eg: Value in a cell = value in the cell 4 columns to it's right.
I tried =(COLUMN()-4)ROW()
but got an error. Seems straightforward but how can i do it? I need the
relative position as this has to be done on several parts of the worksheet
and a formula with variables would be easier.