Duplicate count

[dj mondo]

I would like to take a column, that has a list of phone number and i would like to display as a number how many duplicate are there?? how do i go about it, and there about 2000 phone numbers??


Please any help would be appreciated

 

[dj mondo]

k i guess i didn't explain well. I have multiple columns (i.e. one for first name, one for last name, one for address, and one for phone numbers.) Now if i run a formula or a filter. If it finds a duplicate number, i would like it to remove the number and everything in that row for that number.

the long formula posted here:
=COUNTA(A2:A2000)-SUM(IF(FREQUENCY(IF(A2:A2000<>"",MATCH("~"&A2:A2000,A2:A2000&"",0)),ROW(A2:A2000)-ROW(A2)+1),1))

gives me a count of how many duplicates there is. that is great that is what i need. now to remove those duplicates and put them in a new excel file. is that possible?? or once they have been removed they are gone, i just need to save under a different file name so i have files with no duplicates.

or just a formula to delete duplicate records.

 

[dj mondo]

anything, any ideas. I know started by asking how many duplicates and give me a number. Now they want me to remove those duplicates. please any help would be aprreciate, i have to have this done by the end of the day. again sorry for the bother!!

 

[dj mondo]

i tried the advanced filter but it didn't remove the duplicates??? what do i try now??

 

[dj mondo]

please does anyone have anything, i have no clue how to do this, when i try what has been posted it doesn't give me what i want. how can i delete duplicate records or phone number and the rest of the info.

 

[Bekettay]

Your computer isn’t fully optimized until you’ve removed all unnecessary duplicate files. Let Duplicate Files Deleter remove the duplicates!
let's try duplicate files deleter for better experience
Duplicate Files Deleter
Duplicate Files Deleter is a powerful tool to find and resolve duplicate photos, documents, spreadsheets, MP3's, and more!
Removing duplicates will also help to speed up indexing and reduces back up size and time.
thanks

 

[danielluke1984]

I would recommend you to use Duplicate Files Deleter. I'm sure it should sort out your problem.