Forum Discussion

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.

2 Replies

HansVogelaar
MVP
Mar 13, 2023
rishidavda

In D2:

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

Fill down.
- rishidavda
  Copper Contributor
  Mar 13, 2023
  it worked, thanks a lot vodelaar

Resources