Have a look at the LARGE (and SMALL) functions in Excel Help, and use
these in conjunction with MATCH and INDEX.

Hope this helps.

Pete

On Jan 15, 4:20*pm, petenice81
wrote:
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. *