Rank With Multiple Crieteria

[xlmaniac]

Dear All,
I have a data set spread across thousands of row.
Below is the sample for the same.
I would like to calculate rank based on the Region & Category.
The sample data set is spread across A1:D7.
[TABLE="width: 256"]
<tbody>[TR]
[TD="class: xl63, width: 64"]Region[/TD]
[TD="class: xl63, width: 64"]Category[/TD]
[TD="class: xl63, width: 64"]Sale[/TD]
[TD="class: xl63, width: 64"]Rank[/TD]
[/TR]
[TR]
[TD="class: xl63"]A[/TD]
[TD="class: xl63"]Z[/TD]
[TD="class: xl63"]100[/TD]
[TD="class: xl63"]3[/TD]
[/TR]
[TR]
[TD="class: xl63"]A[/TD]
[TD="class: xl63"]Z[/TD]
[TD="class: xl63"]140[/TD]
[TD="class: xl63"]1[/TD]
[/TR]
[TR]
[TD="class: xl63"]A[/TD]
[TD="class: xl63"]Z[/TD]
[TD="class: xl63"]105[/TD]
[TD="class: xl63"]2[/TD]
[/TR]
[TR]
[TD="class: xl63"]B[/TD]
[TD="class: xl63"]C[/TD]
[TD="class: xl63"]170[/TD]
[TD="class: xl63"]3[/TD]
[/TR]
[TR]
[TD="class: xl63"]B[/TD]
[TD="class: xl63"]C[/TD]
[TD="class: xl63"]215[/TD]
[TD="class: xl63"]2[/TD]
[/TR]
[TR]
[TD="class: xl63"]B[/TD]
[TD="class: xl63"]C[/TD]
[TD="class: xl63"]220[/TD]
[TD="class: xl63"]1


Could Somebody help me with the formulae across D2:D7 which can yield the desired result?
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Domenic]

Try...

D2, confirmed with CONTROL+SHIFT+ENTER, and copied down:

=MATCH(C2,LARGE(IF($A$2:$A$7=A2,IF($B$2:$B$7=B2,$C$2:$C$7)),ROW(INDIRECT("1:"&COUNTIFS($A$2:$A$7,A2,$B$2:$B$7,B2)))),0)

Hope this helps!