Frequency.... I think

[Guest]

HI I have a list of data in column A. The data is a mix of numbers and text.
I need a way to know how often (the frequency) of each value. I tried the
frequency function without any success. A sample of data is below.
A
108JQ8
1108JQ8
1124CB8
124DK5
124DK6
1184BB6
189JV8
1189JV8
124DK6

 

[Guest]

Try:-

=COUNTIF(A$1:A$100,A1)

Drag down,

Mike