Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW DO I REMOVE #VALUE FROM MY SPREAD SHEET | New Users to Excel | |||
How do I remove an unwanted check box from an Excel spread sheet? | Excel Discussion (Misc queries) | |||
Remove Duplication from Validation List? | Excel Discussion (Misc queries) | |||
Remove duplication from validation list? | Excel Worksheet Functions | |||
How do I sort entire spread sheet. Names w/data | Excel Worksheet Functions |