Case Solved
Thank you all so much.
You've all been a great help and I can not tell you how much I've learned in addition to my formula problem.
{=LARGE(IF(B2:B11=$A$1,A2:A11),1)}
Hi Tim,
Thanks for your help on this.
I should have been more clear (new at this)
I'm looking return the Nth value (1st largest 2nd largest etc.) from all of columnn A(sales) providing it meets a match (25) from column B (Group).
Simular to a sum(if).
I know there is no large(if) but...
I'm looking return the Nth value from all of columnn A providing it meets a match from column B.
Simular to a sum(if).
Sales Group
10 12
11 16
13 25
14 25
14 17
15 25
17 25
19 30
20 25
22 25
Thanks
Rob