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.

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. *

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---
--
RyGuy


"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.

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

Vaya con Dios,
Chuck, CABGx3



"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.

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.