Displaying or showing a defined cell name in another cell

[cmj21]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Is there a way to display a defined cell name in another cell?

I would like to define a name for A1 to be "_1A1" and have that displayed in a different cell rather than the value of cell A1. I am ranking data based on the value in the cell, but would like to have the defined name returned in an adjacent cell:

A B C D E
1 rank value cell name
2 10 1 10 _1A1
3 2 2 7 _1A2
4 7 3 2 _1A3

 

[John McGhie]

Not without VBA, no.

But I don't think you need the defined name. It appears that just the cell
address would do you. For which you can use the ADDRESS Function.

Cheers

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel
Is there a way to display a defined cell name in another cell?

I would like to define a name for A1 to be "_1A1" and have that displayed in a
different cell rather than the value of cell A1. I am ranking data based on
the value in the cell, but would like to have the defined name returned in an
adjacent cell:

A B C D E
1 rank value cell name
2 10 1 10 _1A1
3 2 2 7 _1A2
4 7 3 2 _1A3

This email is my business email -- Please do not email me about forum
matters unless you intend to pay!