software

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 quot;10quot; 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 quot;10quot; appears
and to show UK, and then Russia, etc

Example:
China25
Egypt10
UK 10
Germany 80
Russia10
Spain20
Italy 5You can do Data gt; Filter gt; AutoFilter, and then click on the arrow at the top
of your quot;Rankquot; column and select quot;10quot; and it will display all the rows that
contain 10 in that column............Data gt; Filter gt; AutoFilter again to set
everything back to normal.

Vaya con Dios,
Chuck, CABGx3
quot;Doug Laidlawquot; wrote:

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