display cell name or label as formula result

K

kproctor

Help please,

Is there a way to display the cell name or label as the formula result
as opposed to the value of the calculation?

example:

=MAX(CAT,DOG,BIRD)

The value is of CAT is 25.00%. Can the result displayed be CAT instea
of 25.00%?



Any help is greatly appreciated, thank you
 
E

Earl Kiosterud

k,

I can't be sure what you're starting with. Do you have a table listing the
values of these "names," or are they really named cells?
 
E

Earl Kiosterud

k,

It could probably be done with a macro.

How about a table of these:

Table:
25% Cat
60% Dog
15% Bird

Then wrap it in your formula with a VLOOKUP:

=VLOOKUP(MAX(Cat, Dog, Bird), Table, 2)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup_finding all the corresponding cell... 5
Data Consolidation formula 1
Problem in displaying number 4
Array Offset() formula with height of 1 returns duplicates? 9
how to display my cursor cell content in another cell.... 3
Searching multiple fields and then print the entire row from resul 2
countif/sumproduct = criteria with weeknum 2
Next-To-Last, Non-Blank, Rightmost Value in a Row 6

Top