Rank products by date

[SimWHorn]

I have lost hope of me being able to work this one out, although sure easy for you all

I am trying to rank each product individually by date in excel, so effectively each product in the list will have its own rank by date.
For example
Tomato Sauce rank 1, 2, 3, 4 etc.
Black Bean CPU rank 1, 2, 3, 4 etc.

The list could be as small as 4 different line items, or could be for 3,000+ so finding a formula will save LOTS of time

I have tried =rank combined with countifs but not able to get it to do each product in the list individually.

Appreciate any help you can give me

 

[Fluff]

Hi & welcome to MrExcel.
How about

=COUNTIFS(A:A,A2,B:B,">"&B2)+1

 

[SimWHorn]

Hi & welcome to MrExcel.
How about

=COUNTIFS(A:A,A2,B:B,">"&B2)+1

Hi, that is excellent, only thing is I need to have it rank in ascending order, rather than descending if you would be so kind

 

[Fluff]

In that case just change the > to <

 

[SimWHorn]

In that case just change the > to <

What a thicko I am, thank you very very much, awesome!

 

[Fluff]

Glad to help & thanks for the feedback.