Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Find Multiple Maximums
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do you find the SD(standard deviation ) for the multiple reg | Excel Worksheet Functions | |||
Can VLookup function find and list multiple records? | Excel Worksheet Functions | |||
Find and delete part of formula for multiple formulas? | Excel Worksheet Functions | |||
How can I have excel search and add multiple cells to find a targe | Excel Discussion (Misc queries) | |||
How to find the minimum value in a database with multiple values . | Excel Discussion (Misc queries) |