Unique Ranking with Multiple Criteria

Try a helper column to identify the unique items with a formula like this in column D.

=IF(COUNTIFS($B$3:B3,B3,$C$3:C3,C3)=1,ROWS($3:3),"")

Can you do your ranking from that point?

	A	B	C	D
1
2
3		Berry	12/31/2017	1
4		Orange	3/22/2017	2
5		Apple	3/31/2017	3
6		Berry	3/22/2017	4
7		Apple	6/30/2017	5
8		Apple	6/30/2017
9		Orange	3/22/2017
10		Orange	4/18/2017	8