Remember Me?

#1
 cdavidson Posts: n/a
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.

#2
 olasa Posts: n/a

This will return the highest number in each group:
=LARGE(IF(\$A\$2:\$A\$20=12,\$C\$2:\$C\$20),1)
12--3, 11--4, 10--4

HTH
Ola Sandström

Note: This is an Array formula, so it Must be confirmed by holding down
Ctrl and Shift, and then hit Enter. Otherwise it will return #VALUE!

--
olasa
------------------------------------------------------------------------
olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Basem Salman Excel Worksheet Functions 2 July 7th 05 02:41 PM Rich - SG Excel Worksheet Functions 11 July 5th 05 07:44 PM coal_miner Excel Worksheet Functions 1 June 17th 05 05:41 PM Blakepro Excel Discussion (Misc queries) 1 April 1st 05 02:37 AM billybob1 Excel Discussion (Misc queries) 2 January 26th 05 06:11 PM

All times are GMT +1. The time now is 04:27 AM.