Creating a hierarchy of non numerical data ?

Hi there,

hope somebody can help me with this problem I have.
I need to create a table of non numerical data that I can refer to
in a formula, which will compare two pieces of data (both also inside this table), and based upon which is "higher up in the hierarchy" - the cell will display a certain result.

Basically it will be an IF function using non numerical data that has a numerical value / "rank" attached.

Specifically - I need to allocate values to this list in cells A1:A5...
EUR
GBP
AUD
NZD
USD
....where EUR is highest ranked and USD lowest.

Then in column B and C will be listed each of these values but in various combinations.
In column D I will build simple IF functions to show the highest ranked in each combination....

eg B1=EUR C1=GBP D1=IF(B1>C1,B1,C1)

hopefully it's possible (as most things seem to be in excel!)
and any help will be greatly appreciated

many thks in advance
G

You can use the MATCH positions to determine their relative "ranks"

Please Login or Register  to view this content.

Whichever of B1,C1 is listed first in A1:A5 range will be returned in D1

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save