Hi,

Using the formula below, I was able to rank using multiple criteria, but this formula spits out duplicate ranks (1,1,3) and I need it to shoot out unique ranks (1,2,3).

=SUMPRODUCT((B3=B$3:B$9)*(C3<C$3:C$9))+1

Data Set:
Berry 12/31/2017
Orange 3/22/2017
Apple 3/31/2017
Berry 3/22/2017
Apple 6/30/2017
Apple 6/30/2017
Orange 3/22/2017
Orange 4/18/2017

Is there a solution for this?