How to remove duplicated data repeated in a column and keep just o in Excel Worksheet Functions    |   |  Help   Search For:     In:   Office   Excel     Excel General Questions     Excel New users     Excel Application Errors     Excel Charts     Excel Programming     Excel Setup     Excel Worksheet Functions              Kitti 7/26/2007 8:28 AM PST   Question   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     Was this post helpful to you?         Reply |   Top           Peo Sjoblom 7/26/2007 8:41 AM PST   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 -- Regards, Peo Sjoblom "Kitti" <Kitti@discussions.microsoft.com> wrote in message news:688EB97A-BDBD-4D1D-890D-FB1F8454DAF9@microsoft.com... > 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     Was this post helpful to you?         Reply |   Top           Kitti 7/26/2007 9:02 AM PST   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 "Peo Sjoblom" wrote: > 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 > > > -- > Regards, > > Peo Sjoblom > > > > "Kitti" <Kitti@discussions.microsoft.com> wrote in message > news:688EB97A-BDBD-4D1D-890D-FB1F8454DAF9@microsoft.com... > > 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 > > >     Was this post helpful to you?         Reply |   Top           Peo Sjoblom 7/26/2007 9:11 AM PST   Answer   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 -- Regards, Peo Sjoblom "Kitti" <Kitti@discussions.microsoft.com> wrote in message news:E2BFFF80-C276-42A2-87BA-4C62CB2DA5AF@microsoft.com... > 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 > > "Peo Sjoblom" wrote: > >> 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 >> >> >> -- >> Regards, >> >> Peo Sjoblom >> >> >> >> "Kitti" <Kitti@discussions.microsoft.com> wrote in message >> news:688EB97A-BDBD-4D1D-890D-FB1F8454DAF9@microsoft.com... >> > 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 >> >> >>     Was this post helpful to you?         Reply |   Top           pea 5/9/2008 2:36 PM PST   Could someone help me I need to remove duplicate data in one column only I tried to filter but it's just not working. "Peo Sjoblom" wrote: > 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 > > > -- > Regards, > > Peo Sjoblom > > > > "Kitti" <Kitti@discussions.microsoft.com> wrote in message > news:688EB97A-BDBD-4D1D-890D-FB1F8454DAF9@microsoft.com... > > 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 > > >     Was this post helpful to you?         Reply |   Top           Duke Carey  7/26/2007 10:37 AM PST   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 "Kitti" wrote: > 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     Was this post helpful to you?         Reply |   Top         Return to Microsoft Communities   Notify me of replies