Count Frequentness

R

RoadKing

Good evening:
Is it possible to count how many times a string of numbers appears in a
column? I am working on a project that has approximately 1000 telephone
numbers. I need a count on how many times a particular number appears in a
column.
Thank you in advance
John
 
B

Bernard Liengme

Is it really a "number" or is it a telephone number complete with hyphens?
=COUNTIF(A1:A1000,2345) if number
=COUNTIF(A1:A100, "555-1212") if text
In either case the last argument can reference a cell: COUNTIF(A1:A1000,B1)
best wishes
 
R

RichardSchollar

Hi John

If you have a mix of numbers and text, you'd be best off using
Sumproduct:

=SUMPRODUCT(ISNUMBER(FIND("0123",A1:A10))+0)

although note that this won't count multiple occurrences of the number
string in a single cell (ie that will only count as 1 find) - which
may or may not be what you require.

Hope this helps!

Richard
 
Top