Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to lookup when range contains multiple identical entries?
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to lookup when range contains multiple identical entries?
You can do Data Filter AutoFilter, and then click on the arrow at the top
of your "Rank" column and select "10" and it will display all the rows that contain 10 in that column............Data Filter AutoFilter again to set everything back to normal. Vaya con Dios, Chuck, CABGx3 "Doug Laidlaw" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |