Advertisement
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 all! We have been experiencing an issue on site where threads have been missing the latest postings. The platform host Vanilla are working on this issue. A workaround that has been used by some is to navigate back from 1 to 10+ pages to re-sync the thread and this will then show the latest posts. Thanks, Mike.
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

  • 10-05-2011 4:25pm
    #1
    doyler442
    Registered Users, Registered Users 2 Posts: 325 ✭✭


    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


Comments

  • #2
    Mr November
    Registered Users, Registered Users 2 Posts: 60 ✭✭Mr November


    =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)


Advertisement