Filter for the top 3, so that if you have duplicate values in the top 3,
you'll see them

Tyro

"petenice81" wrote in message
...
I'm trying to find a way to display the top 3 items in a random list of
more
than 7 components. Assuming I have the following data:

Column A (value) Column B (components)
2.3 z
3.5 y
1.2 x
6.2 w
4.5 v

I want to return the following:

Top 3 highest by component

6.2 w
4.5 v
3.5 y


Is there an easy way to do this? I'm thinking I need to use VLOOKUP and
possibly the RANK function, but can't seem to get the logic figured out.
Thanks.