how do i sort a spread sheet and remove duplication
 

I need to sort a large spreadsheet - by the column of account numbers - (over
50K) with duplications. I need to remove the duplications and keep only 1
entry of each account

how do i sort a spread sheet and remove duplication
 

One way is to use autofilter on a helper col which flags the duplicates

Assume account numbers running in A2 down
Insert a new col B (if required)
Put in B2:
=IF(COUNTIF(A$2:A2,A2)1,"x","")
Copy B2 down to the last row of data in col A. Col B will flag all duplicate
account numbers found in col A with an "x". Then apply autofilter on col B,
select: "x" from the droplist in B1. Select all the filtered rows,
right-click Delete rows. Remove autofilter.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Shiraz" wrote:
I need to sort a large spreadsheet - by the column of account numbers - (over
50K) with duplications. I need to remove the duplications and keep only 1
entry of each account

how do i sort a spread sheet and remove duplication
 

datafilteradvanced filterunique

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Shiraz" wrote in message
...
I need to sort a large spreadsheet - by the column of account numbers -
(over
50K) with duplications. I need to remove the duplications and keep only 1
entry of each account

how do i sort a spread sheet and remove duplication
 

DataFilterAdvanced FilterUnique records only will return the uniques which
you can copy to another location.

For more on this see Debra Dalgleish's site

http://www.contextures.on.ca/xladvfi....html#FilterUR


Gord Dibben MS Excel MVP

On Wed, 28 Nov 2007 06:03:02 -0800, Shiraz
wrote:

I need to sort a large spreadsheet - by the column of account numbers - (over
50K) with duplications. I need to remove the duplications and keep only 1
entry of each account