Recent content by Robs89wag

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