A 4

B 3

C 2

D 2

E 2

F 2

G 2

H 1

I 1

J 1

I want to find a formula that tells me that i’ve been to x places, x amount of times. So at the moment x=2. If I go to C again, which makes C=3, then x=3.

I have made a COUNTIF formula to cumulatively count the number of times I’ve been to each place.

Can anyone help?

Thank you