How can I choose top two numbers in a column?
 

I want to choose the top two values from a column (preferably multiple
columns or an array). For example, if the column contains the numbers 1, 2,
3, 3, 4, 4, 5, 2, 5. I would like two have two cells below that column
choose and display 5 and 5.
Another example:
column contains: 5, 7, 8, 7, 8, 7, 9, 8, 8, 12. Then the other two cells
should display 12 and 9.
Any help would be appreciated.
P.S. The only values I'm dealing with are 0, 1, 2 and 3 so if you know of a
workaround that would work with only 4 different values that would be fine.

=LARGE(rng,1) in cell 1
=LARGE(rng,2) in cell2

or

select cell 1 and 2 together and

=LARGE(rng,{1;2}) array entered using CTRL+SHIFT+ENTER

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Doug" wrote in message
...
I want to choose the top two values from a column (preferably multiple
columns or an array). For example, if the column contains the numbers 1,
2,
3, 3, 4, 4, 5, 2, 5. I would like two have two cells below that column
choose and display 5 and 5.
Another example:
column contains: 5, 7, 8, 7, 8, 7, 9, 8, 8, 12. Then the other two cells
should display 12 and 9.
Any help would be appreciated.
P.S. The only values I'm dealing with are 0, 1, 2 and 3 so if you know of
a
workaround that would work with only 4 different values that would be
fine.

Well that's as easy as I thought it should have been. Thank you.
Doug

"Ken Wright" wrote:

=LARGE(rng,1) in cell 1
=LARGE(rng,2) in cell2

or

select cell 1 and 2 together and

=LARGE(rng,{1;2}) array entered using CTRL+SHIFT+ENTER

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Doug" wrote in message
...
I want to choose the top two values from a column (preferably multiple
columns or an array). For example, if the column contains the numbers 1,
2,
3, 3, 4, 4, 5, 2, 5. I would like two have two cells below that column
choose and display 5 and 5.
Another example:
column contains: 5, 7, 8, 7, 8, 7, 9, 8, 8, 12. Then the other two cells
should display 12 and 9.
Any help would be appreciated.
P.S. The only values I'm dealing with are 0, 1, 2 and 3 so if you know of
a
workaround that would work with only 4 different values that would be
fine.

LOL - You're welcome

--
Regards
Ken.......................


"Doug" wrote in message
...
Well that's as easy as I thought it should have been. Thank you.
Doug

"Ken Wright" wrote:

=LARGE(rng,1) in cell 1
=LARGE(rng,2) in cell2

or

select cell 1 and 2 together and

=LARGE(rng,{1;2}) array entered using CTRL+SHIFT+ENTER

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03


--------------------------------------------------------------------------
--
It's easier to beg forgiveness than ask permission :-)

--------------------------------------------------------------------------
--

"Doug" wrote in message
...
I want to choose the top two values from a column (preferably multiple
columns or an array). For example, if the column contains the numbers
1,
2,
3, 3, 4, 4, 5, 2, 5. I would like two have two cells below that
column
choose and display 5 and 5.
Another example:
column contains: 5, 7, 8, 7, 8, 7, 9, 8, 8, 12. Then the other two
cells
should display 12 and 9.
Any help would be appreciated.
P.S. The only values I'm dealing with are 0, 1, 2 and 3 so if you know
of
a
workaround that would work with only 4 different values that would be
fine.