My Problem:

I need to write a formula that will return the 'highest' number in a group
of ranked numbers.


Month Count Rank Required Unique Max # Sought
------- ---------------- -----------------
--------------------------
12 20 2
3
12 20 3
12 40 1
11 15 2
4
11 15 3
11 10 4
11 20 1
10 30 1
4
10 30 2
10 25 3
10 25 4

As per the example above, I need a formula that will return only one '3',
when referencing the group of 12's, and return only one '4' when referencing
the group of 11's, etc.

Many thanks for your assistance.