Seems simple but... no dice. Looking for duplicate data in a column.

**TDellaPorta** · 10-29-2014, 06:29 PM

I'm sure this is an easy one. In Excel 2013 I have a workbook showing the phone numbers of 2600 texts my daughter sent and recvd last month. I would just like to see a list of the individual phone numbers and how many times each particular number appeared out of the 2600 listed.

ex. Imagine this is the list of phone numbers.
123-456-7879
246-555-1234
246-555-1234
987-654-3211
123-456-7879
123-456-7879
987-654-3211

I'd like to see something like this generated from it...

123-456-7879 (3), 246-555-1234 (2), 987-654-3211 (2) With the number in () representing the number of times it appeared in the entire list.

Thanks!

Todd DP

**martindwilson** · 10-29-2014, 07:34 PM

by far the easiest way is say that list is in column A starting A2
then in column b starting b2 put
=IF(COUNTIF($A$2:A2,A2)=COUNTIF($A$2:$A$5000,A2),COUNTIF($A$2:$A$5000,A2),"")
fill down to end
then auto filter on column b ignoring blanks

**TMS** · 10-29-2014, 07:36 PM

Use a Pivot Table

	A	B	C	D	E
1	Phone
2	123-456-7879
3	246-555-1234
4	246-555-1234
5	987-654-3211
6	123-456-7879
7	123-456-7879
8	987-654-3211
9			Phone	Calls
10			123-456-7879	3
11			246-555-1234	2
12			987-654-3211	2
13			Grand Total	7
14

Regards, TMS

**TDellaPorta** · 10-30-2014, 07:48 AM

Hey Thanks so much. I tried what you suggested with plain numbers and it worked like a charm. When I tried to apply it to my actual data (phone numbers) it wouldn'

t work. Any chance you could send me a simple workbook using your method with 10 or so american phone numbers? xxx-xxx-xxxx is the format.
Thx again!