ExcelBanter - Frequency.... I think

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Frequency.... I think (https://www.excelbanter.com/excel-worksheet-functions/149684-frequency-i-think.html)

DP7

Frequency.... I think

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

Mike H

Frequency.... I think

Try:-

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

Drag down,

Mike

"DP7" wrote:

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

All times are GMT +1. The time now is 12:54 PM.