Excel Formula to Rank between Name and Subject with respect to mark

[rishidavda]

Excel Formula to Rank between Name and Subject with respect to mark as per below example.

[#2]

@rishidavda 

In D2:

=COUNTIFS($A$2:$A$1000,A2,$C$2:$C$1000,">="&C2)

Fill down.

[#3]

it worked, thanks a lot vodelaar