Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to compute StDev of only nonzero entries in a range? | Excel Worksheet Functions | |||
Identical Name on multiple workbook pages | Excel Discussion (Misc queries) | |||
Conditional Lookup on Multiple Criteria | Excel Worksheet Functions | |||
Lookup Value is Between Range 1 and Range 2 | Excel Worksheet Functions | |||
Lookup Value is Between Range 1 and Range 2 | Excel Worksheet Functions |