View Single Post
  #1   Report Post  
Doug
 
Posts: n/a
Default 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.