Search and count occurrences

[alentejano]

Hi all,

I need to do some macro to search in a collumn for distinct occurences of values . And then count to each one the number of occurences.

Here is an example of what i need .

occ |distinct occ | nr occ
A A 5
A B 4
A C 2
B D 1
B F 1
C G 1
C H 1
D I 1
F
G
H
I
A
B
B
A

Many thanks for the attention,


Bruno

 

[mikerickson]

If those are columns A,B,C, then =COUNTIF(A:A,B1) in C1 and drag down.

 

[alentejano]

In the beginning I only have the first collumn, Then I have to search for all the distinct values and fill the next collumn.
After that I have to count for each one of this values the number of occurences.

Thanks for the attention

 

[mikerickson]

You could use a Pivot Table.