Hi,
I have excel 2003 and I need to remove duplicates.

any help is appreciated.

best regards.

Shiblie

hi,
see this site....
http://cpearson.com/excel/Duplicates.aspx

regards
FSt1

"Shiblie Bshara" wrote:

Hi,
I have excel 2003 and I need to remove duplicates.

any help is appreciated.

best regards.

Shiblie

I wasn't in on this thread, but I need to thank you for posting, as I
have wondered this for ages. Some minds make the presumption that
"duplicates" are EXACT duplicates, when in fact, I often need to analyze
which of 2 I would like to delete. Thanks (would insert flowers here but
don't know how to)

Regards,

P D Sterling
New York, Texas & Texas, New York


FSt1 wrote:
hi,
see this site....
http://cpearson.com/excel/Duplicates.aspx

regards
FSt1

"Shiblie Bshara" wrote:

Hi,
I have excel 2003 and I need to remove duplicates.

any help is appreciated.

best regards.

Shiblie

We can help you if you post some of your data and give more details.


Thx,
JP


On Jan 27, 8:51*am, "Shiblie Bshara" wrote:
Hi,
I have excel 2003 and I need to remove duplicates.

any help is appreciated.

best regards.

Shiblie

Hey again,

the file is a contact details collected from multi sources so I would have
something like:

Name Phone #
Company 1 000000000
Company 2 111111111
Company 3 22222222
Company 1 000000001



thanks in advance


Shiblie.B

"JP" wrote in message
...
We can help you if you post some of your data and give more details.


Thx,
JP


On Jan 27, 8:51 am, "Shiblie Bshara" wrote:
Hi,
I have excel 2003 and I need to remove duplicates.

any help is appreciated.

best regards.

Shiblie

Hi there.

Try this link, which may help you with your problem:-

http://support.microsoft.com/kb/262277

Let us know how you get on,

Kind regards,
Matt Richardson
http://teachr.blogspot.com

On Jan 28, 7:29 am, "Shiblie Bshara" wrote:
Hey again,

the file is a contact details collected from multi sources so I would have
something like:

Name Phone #
Company 1 000000000
Company 2 111111111
Company 3 22222222
Company 1 000000001

thanks in advance

Shiblie.B

"JP" wrote in message

...

We can help you if you post some of your data and give more details.

Thx,
JP

On Jan 27, 8:51 am, "Shiblie Bshara" wrote:
Hi,
I have excel 2003 and I need to remove duplicates.

any help is appreciated.

best regards.

Shiblie

Thanks, but you need to explain the desired outcome. Do you want a
list of unique companies? Phone numbers? Something else?

--JP

On Jan 28, 2:29*am, "Shiblie Bshara" wrote:
Hey again,

the file is a contact details collected from multi sources so I would have
something like:

Name * * * * * * * * * * * * * * * *Phone #
Company 1 * * * * * * * * * * * *000000000
Company 2 * * * * * * * * * * * *111111111
Company 3 * * * * * * * * * * * * 22222222
Company 1 * * * * * * * * * * * * *000000001

thanks in advance

Hi!
Please, try a small add-in that i usually use often:
http://www.office-excel.com/excel-ad...tes-excel.html
Best regards,
Eugene

"Shiblie Bshara" wrote in message
...
Hi,
I have excel 2003 and I need to remove duplicates.

any help is appreciated.

best regards.

Shiblie