| Home |
| Search |
| Today's Posts |
|
#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 |
| 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 | |||
Threaded Mode
