COLUMNS question - current cell relative to A1

[colbymack]

I am trying to find out a way to have Excel tell me either A) the current cell reference for the cell on which the selection is, or b) the number of columns relative to A1 for the current cell. I am somewhat familiar with the columns command, but do not know the formula to get the current address.

i.e. if I am in C2, I would like to have a formula in C2 that results in the value of 3, which represents the relative column number of column C to column A.

Any help would be appreciated.

Thanks in advance,
Colbymack

 

[NBVC]

Do you mean?

=Column(C2)

 

[Joe4]

Take a look at the ROW() and COLUMN() functions.

They will give you the numerical value of the row/column you are in.

 

[colbymack]

jmiskey,
That was perfect. I thought I tried Column before and that it was always returning 1. Apparently some operator error, as it now appears to be doing exactly as I want it to.

Thanks much,
Colbymack