I have a list of data that I need to rank from 1-?? based on two sets of
criteria. here is an example of what I need.

Customer Name Product Sales Rank

Customer A Product 1 100 1
Customer A Product 1 50 3
Customer A Product 1 75 2
Customer A Product 2 540 2
Customer A Product 2 390 3
Customer A Product 2 600 1

So my question is, when Product changes, I want the ranking to start over
again. Is there a formula I can use to do this? Can I use an if statement
combined with a rank? (The product is not a number, it's text)

Thank you!!!!!