View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jacob_F_Roecker Jacob_F_Roecker is offline
external usenet poster
 
Posts: 4
Default 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!