How to remove duplicated data repeated in a column and keep just o

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
Could someone tell me how I might remove data (phone numbers) in a column
and only retain one a duplicated number in the column just once? Basically
needing to remove duplicates.
Thank you
 
Makes sure you have a header, if not create one, select the data (header
included), do data>filter>advanced filter, select copy to another location
(then select where to copy), then select unique records only and click OK
 
Thanks for getting back to me so quickly. I am trying to do as you've
directed, but when I come to "(then select where to copy)" I don't know how
to enter the location to send it to. It's just a single column, so I was
going to put the copy in column C and I have 3646 rows. Any further
instructions on this would be truly appreciated.
Thank you
 
When you get to the copy to another location part, just click in the empty
box to the right of "Copy to:" to place the cursor there then click in the
first cell where you want it, so if you want it starting in C2 for instance
just click in cell C2 and the box will change to

Sheet1!$C$2

Sheet1 of course will be the sheet name you are using

then select unique records only and click OK
 
If you happen to have Excel 2007, the Data ribbon has an icon for removing
duplicates from a table or range of data.

I've test it only the slightest bit and it seems to work
 
Could someone help me I need to remove duplicate data in one column only I
tried to filter but it's just not working.
 
Back
Top