I have been to the following places, the following number of times.
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...