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 datafilteradvanced filter, select copy to another location
(then select where to copy), then select unique records only and click OK


--
Regards,

Peo Sjoblom



"Kitti" wrote in message
...
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

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 datafilteradvanced filter, select copy to another location
(then select where to copy), then select unique records only and click OK


--
Regards,

Peo Sjoblom



"Kitti" wrote in message
...
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

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" wrote in message
...
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 datafilteradvanced filter, select copy to another
location
(then select where to copy), then select unique records only and click OK


--
Regards,

Peo Sjoblom



"Kitti" wrote in message
...
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

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

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 datafilteradvanced filter, select copy to another location
(then select where to copy), then select unique records only and click OK


--
Regards,

Peo Sjoblom



"Kitti" wrote in message
...
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