VBA needed to break the tie!

[erutherford]

Over the years you folks have helped me to build a wonderful system has saved our club many hours every year at our annual concours (car show). For the first time the system didn't know what to do with a tie score.
2nd and 3rd place tied, the system showed the 2nd place finisher twice. My work around was after the tie breaker was settled, I added a point to 2nd place and then the system displayed perfectly. I would prefer it display the two that tied. Below is the code used.

=INDEX(Pts,MATCH(MAX(IF(Div=A92,IF(Class=A93,Pts))),IF(Div=A92,IF(Class=A93,Pts)),0))

- This displays 1st place

=INDEX(Pts,MATCH(LARGE(IF(Div=A92,IF(Class=A93,Pts)),2),IF(Div=A92,IF(Class=A93,Pts)),0))

- This displays 2nd Place

=INDEX(Pts,MATCH(LARGE(IF(Div=A92,IF(Class=A93,Pts)),3),IF(Div=A92,IF(Class=A93,Pts)),0))

- This displays 3rd Place

I am not opposed to a MsgBox popping up saying there is a tie if that's easier.

Many thanks to everyone at MrExcel!!!

 

[erutherford]

I think this is a start in the right direction.

=RANK(R3,$R$2:$R$40)

I need to look for "W" in column C and a "O" in column D, then the "Rank" formula.
I'll keep searching

 

[myall_blues]

It would be helpful if you provided some context and example data, preferably using XL2BB.
You know your sheet intimately, but we have no idea what is in A92, A93, the named range Pts, or in columns R, C or D.