Selecting the Second largest number
 

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!

Selecting the Second largest number
 

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

"Jacob_F_Roecker" wrote:

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!

Selecting the Second largest number
 

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.

--
Kind regards,

Niek Otten

"Jacob_F_Roecker" wrote in message
...
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

"Jacob_F_Roecker" wrote:

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!

Selecting the Second largest number
 

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

Jacob_F_Roecker wrote:

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!

--

Dave Peterson