Here's a simple example of what I'm trying to do on a larger scale. I have a
raw list of data as below. I rank them elsewhere and then I use a lookup
function to find match the country to the value. The problem is that when I
do a lookup on "10" it gives me Egypt every time because it is the first
match that it finds. How do I get it to skip Egypt the next time "10" appears
and to show UK, and then Russia, etc
Example:
China 25
Egypt 10
UK 10
Germany 80
Russia 10
Spain 20
Italy 5
Bookmarks