I have same data where I want to count how often a reference occurs, and then rank it by a specific stipulation.
Below is my example.
So the formula should be able to count that ABC is in column A twice and then rank them based on column B.
I know I've done this before but just cant remember what I did.
Cheers
Below is my example.
| Column A | Column B | What I want column C to show |
| ABC | 00:00:00 | 1 |
| ABC | 00:04:00 | 2 |
| BAC | 00:00:00 | 1 |
| BAC | 00:03:50 | 3 |
| BAC | 00:02:03 | 2 |
So the formula should be able to count that ABC is in column A twice and then rank them based on column B.
I know I've done this before but just cant remember what I did.
Cheers
