To get the second largest, use the LARGE function with 2 as its position
argument...

=INDEX(Migration!$CW$2:$CW$3900,MATCH(1,(Migration !$A$2:$A$3900=A2)*(Migration!$B$2:$B$3900=B2)*(Mig ration!$CK$2:$CK$3900=LARGE(IF((Migration!$A$2:$A$ 3900=A2)*(Migration!$B$2:$B$3900=B2),Migration!$CK $2:$CK$3900),2)),0))

Actually, you can replace the last number 2 (position argument for
LARGE) with ROWS($CY$2:CY2), enter the formula in CY2, and copy down.
This will give you the first largest, second largest, third largest,
etc.

Hope this helps!

kkendall Wrote:
Domenic, thanks again for the help. I am on to my next and last issue
with this formula.

I need to use it in a different location to basically concatenate every
entry that it finds, less the max data value. I hope that makes sense.
So what I am trying to see is if I can add something to it less max-1,
max-2, etc to pull each record in in order. Is that at all possible?

Would it be something like:

=INDEX(Migration!$CW$2:$CW$3900,MATCH(1,(Migration !$A$2:$A$3900=A2)*(Migration!$B$2:$B$3900=F2)*(Mig ration!$CK$2:$CK$3900=MAX(-1)*(IF((Migration!$A$2:$A$3900=A2)*(Migration!$B$2 :$B$3900=F2),Migration!$CK$2:$CK$3900))),0))


--
Domenic
------------------------------------------------------------------------
Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785
View this thread: http://www.excelforum.com/showthread...hreadid=393096