In column A, I have a set of unique values, and in column B, I have another set of unique values. I'm trying to develop a formula that would tell me the rank of the most common value in column B, given the value in column A.
So for example, for AA, it'd be #1 Dog, #2 Cat, #3 Bird.
I've been trying to use a combination of countifs and mode, without much success.
So for example, for AA, it'd be #1 Dog, #2 Cat, #3 Bird.
AA | Cat |
AA | Cat |
AA | Dog |
AA | Dog |
AA | Dog |
AA | Dog |
AA | Bird |
BB | Cat |
BB | Cat |
BB | Bird |
I've been trying to use a combination of countifs and mode, without much success.