Cell Refrencing Problems

  • Thread starter Thread starter slaughter
  • Start date Start date
S

slaughter

Here is the problem:

I need to find the slope of a set of data located in Column G, but I d
not want the SLOPE function to contain any direct reference to Colum
G. Instead, I would like the slope function to reference a cell tha
contains the leter "G". Is this possible? Here is a little example.

Column C has the list of data

Cell A1: C

Slope Eq: =slope(somelinktoA1:somelinktoA1)
--> the result should give the slope of column C


Thanks for any help
 
Here is the problem:

I need to find the slope of a set of data located in Column G, but I do
not want the SLOPE function to contain any direct reference to Column
G. Instead, I would like the slope function to reference a cell that
contains the leter "G". Is this possible? Here is a little example.

Column C has the list of data

Cell A1: C

Slope Eq: =slope(somelinktoA1:somelinktoA1)
--> the result should give the slope of column C
Click to expand...

If I understand you correctly, the INDIRECT worksheet function may do
what you want. Look in on-line help to see how it's used.
 
Back
Top