Microsoft Excel Cell Value Based on its Own Reference Point

doyler442 · 2011-05-10 15:25:21

Hi Just wondering if someone can help me with this: I want to give a cell a value based on its reference point of its own Column and Row For example the cell at C3 would have a value of C3 Then if I need to add a row above this, the value of that same cell would then become C4 Is this easy or possible to do? Cheers for the…

10-05-2011 04:25PM

#1

doyler442

Registered Users, Registered Users 2 Posts: 325 ✭✭

Join Date: December 2006

Posts: 210

Hi

Just wondering if someone can help me with this:

I want to give a cell a value based on its reference point of its own Column and Row

For example the cell at C3 would have a value of C3

Then if I need to add a row above this, the value of that same cell would then become C4

Is this easy or possible to do?

Cheers for the help

0

Comments

#2 13-05-2011 04:30PM

Mr November

Registered Users, Registered Users 2 Posts: 64 ✭✭

Join Date: March 2011

Posts: 57

=ADDRESS(ROW(),COLUMN())

This will return the cell reference e.g. C3 --> $C$3

If you don't want the $ contained in it you can remove them with something like this

=MID(ADDRESS(ROW(),COLUMN()),2,1)&MID(ADDRESS(ROW(),COLUMN()),4,5)

0