Forum Discussion

rishidavda's avatar
rishidavda
Copper Contributor
Mar 13, 2023

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

Excel Formula to Rank between Name and Subject with respect to mark as per below example.  
Charting
HansVogelaar's avatar
HansVogelaar
MVP
Mar 13, 2023

rishidavda 

In D2:

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

Fill down.

rishidavda's avatar
rishidavda
Copper Contributor
Mar 13, 2023
it worked, thanks a lot vodelaar

Resources