If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

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 3: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 3:30pm

Mr November

Registered Users, Registered Users 2 Posts: 60 ✭✭

Join Date: March 2011

Posts: 54

=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