My data looks like this:

Date Product Sales Rank
1-Mar ABC 25 2
1-Mar DEF 50 1
1-Mar GHI 10 4
1-Mar JKL 15 3
1-Mar MNO 10 4
2-Mar GHI 100 2
2-Mar JKL 200 1
2-Mar MNO 25 3

I am trying to find a formula for ColD (Rank) that will place the rank of
the product (based on Sold) for each day.

Thank you in advance.