LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posts: n/a
Default 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
12 20 3
12 40 1
11 15 2
11 15 3
11 10 4
11 20 1
10 30 1
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.
  #2   Report Post  
Posts: n/a

This will return the highest number in each group:
12--3, 11--4, 10--4

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's Profile:
View this thread:

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
how do you find the SD(standard deviation ) for the multiple reg Basem Salman Excel Worksheet Functions 2 July 7th 05 02:41 PM
Can VLookup function find and list multiple records? Rich - SG Excel Worksheet Functions 11 July 5th 05 07:44 PM
Find and delete part of formula for multiple formulas? coal_miner Excel Worksheet Functions 1 June 17th 05 05:41 PM
How can I have excel search and add multiple cells to find a targe Blakepro Excel Discussion (Misc queries) 1 April 1st 05 02:37 AM
How to find the minimum value in a database with multiple values . billybob1 Excel Discussion (Misc queries) 2 January 26th 05 06:11 PM

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

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright ©2004-2023 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"