Posted to microsoft.public.excel.programming

Billy[_3_] Billy[_3_] is offline

external usenet poster

Posts: 2

Removing duplicate entries

This should be simple. I have a spreadsheet with one column and several
thousand rows. Each cell contains a phone number. I want to delete all but
one of each duplicate number so that I end up with all unique numbers. How
can this be done quickly?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Removing duplicate entries	Roger Bell	New Users to Excel	2	June 23rd 07 10:20 AM
excel - removing duplicate entries in spreadsheet	prh	Excel Discussion (Misc queries)	1	September 29th 06 01:05 PM
Removing duplicate entries	katiek648	Excel Discussion (Misc queries)	2	August 4th 06 06:56 PM
removing duplicate entries	armagan	Excel Discussion (Misc queries)	1	June 12th 06 05:42 PM
Removing duplicate entries.	dh01uk	Excel Discussion (Misc queries)	2	January 13th 06 03:51 PM

All times are GMT +1. The time now is 03:27 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us