Selecting the Second largest number

[Jacob_F_Roecker]

I have a column with a series of percentages. The end of the table varies in
size vertically depending on the size of the source data. The bottom cell is
always 100%.

I want in the adjacent column to have it label the second, third, and fourth
highest values.

I know how to get the highest using the =Max() command. How do I get second
highest?


Example 1
1 65%
2 5%
3 12%
4 3%
5 15%
Total 100%

Example 2
1 76%
2 12%
3 12%
Total 100%

To make sure I'm communicating properly I've included these examples. If I
can learn how to find the second highest value in a range I'll be able to do
all the rest.

I'm getting pretty good at this stuff.

Once I figured out that understanding spreadsheets wasn't genetic it changed
my attitude towards them.

Thanks for your help!

 

[Jacob_F_Roecker]

OK I just found the RANK function

This should do it for me.

Sorry to waste your time.

I didn't know the function existed.

Genetics you know.


-Jacob

 

[Niek Otten]

If you still have problems, post again in this same thread because it has
probably been marked by those who are interested or even knowledgeable.

 

[Dave Peterson]

You may want to look at =large(), too.

I have a column with a series of percentages. The end of the table varies in
size vertically depending on the size of the source data. The bottom cell is
always 100%.

I want in the adjacent column to have it label the second, third, and fourth
highest values.

I know how to get the highest using the =Max() command. How do I get second
highest?

Example 1
1 65%
2 5%
3 12%
4 3%
5 15%
Total 100%

Example 2
1 76%
2 12%
3 12%
Total 100%

To make sure I'm communicating properly I've included these examples. If I
can learn how to find the second highest value in a range I'll be able to do
all the rest.

I'm getting pretty good at this stuff.

Once I figured out that understanding spreadsheets wasn't genetic it changed
my attitude towards them.

Thanks for your help!