Rankif 3 criteria with tie breaker

**huy_le** · 09-23-2014, 07:46 PM

Hi,

I want to be able to rank based on 3 criteria and also have tie breaker (i.e. if the same values, break them into different ranks not ties).

Thanks in advance.

**kvsrinivasamurthy** · 09-24-2014, 02:00 AM

IN D2, then dragdown.

Please Login or Register  to view this content.

**samba_ravi** · 09-24-2014, 02:34 AM

=SUMPRODUCT(--(--($A$2:$A$28=A2)*--($B$2:$B$28=B2)*($C$2:$C$28)>C2))+COUNTIFS(A$2:A2,A2,B$2:B2,B2,C$2:C2,C2)
Try this in D2 and copy towards down

**huy_le** · 09-24-2014, 01:13 PM

Thanks guy for your help.
kvsrinivasamurthy: Your formula does not break ties.
nflsales: Your formula appears to be working. Thanks!

Rankif 3 criteria with tie breaker

LinkBack

Thread Tools

Rate This Thread

Display

Rankif 3 criteria with tie breaker

Re: Rankif 3 criteria with tie breaker

Re: Rankif 3 criteria with tie breaker

Re: Rankif 3 criteria with tie breaker

Thread Information

Users Browsing this Thread

Similar Threads

Rankif with tie breaker

Rankif with 2 criteria

[SOLVED] Rankif with 2 criteria

[SOLVED] Help with sumproduct for mutliple criteria ranking with a tie breaker

Rankif?

Bookmarks

Bookmarks

Posting Permissions