Show the top three items in a list

[petenice81]

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.

 

[Pete_UK]

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

 

[ryguy7272]

One way:
=LARGE($A$1:$A$20,1)
=LARGE($A$1:$A$20,2)
=LARGE($A$1:$A$20,3)

This may be helpful too:
=RANK(A1,$A$1:$A$20,1)


Regards,
Ryan---

 

[CLR]

Data > Filter > Autofilter > choose drop down arrow for column A and select
Top 10, then reset for Top 3

Vaya con Dios,
Chuck, CABGx3

 

[Tyro]

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

Tyro