MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Large(If)


Posted by Richard Larocque on January 07, 2002 3:42 PM

IndustryRating Stock Symbol (What I'm looking to get)

a 9 q q
a 7 w
a 5 e
b 3 r
b 1 t
b 8 y y
b 6 u
c 4 i i
c 2 o
d 3 p p

This is the data I'm working with. What I'd like to do is a sort of a Large(If) formula. For example, I'd like to find the largest value in the rating column for every change in the industry column and return a value into a fourth column from the stock ticker column.


Posted by Aladin Akyurek on January 07, 2002 3:56 PM

Richard --

In D2 enter and copy down: =IF(SUMPRODUCT(MAX(($A$2:$A$11=A2)*($B$2:$B$11)))=B2,C2,"")

I assumed your sample data to be in A2:C11.

Aladin

======

Posted by Richard Larocque on January 07, 2002 5:25 PM

Aladin! You're a Godsend! Thanks so much!

Richard