| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatically elliminate duplicates within a spreadsheet?
Hi everyone, Operating with huge lists of domain names and other similar statistical stuff I desperately need to find a solution in order to eliminate similar entries within a table. Any ideas as to a possible remedy (formula or function)? Thanx in advance ;) -- frenchbox ------------------------------------------------------------------------ frenchbox's Profile: http://www.excelforum.com/member.php...o&userid=29271 View this thread: http://www.excelforum.com/showthread...hreadid=489906 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Automatically elliminate duplicates within a spreadsheet?
You could load it into Access or MSDE and use a simple query to extract
DISTINCT rows. Can be much, MUCH easier than fiddling with it in Excel "frenchbox" wrote: Hi everyone, Operating with huge lists of domain names and other similar statistical stuff I desperately need to find a solution in order to eliminate similar entries within a table. Any ideas as to a possible remedy (formula or function)? Thanx in advance ;) -- frenchbox ------------------------------------------------------------------------ frenchbox's Profile: http://www.excelforum.com/member.php...o&userid=29271 View this thread: http://www.excelforum.com/showthread...hreadid=489906 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Automatically elliminate duplicates within a spreadsheet?
DataFilterAdvanced Filter.
Check "unique records only" and "copy to another location". For more on this see Debra Dalgleish's site http://www.contextures.on.ca/xladvfilter01.html Gord Dibben Excel MVP On Thu, 1 Dec 2005 12:44:43 -0600, frenchbox wrote: Hi everyone, Operating with huge lists of domain names and other similar statistical stuff I desperately need to find a solution in order to eliminate similar entries within a table. Any ideas as to a possible remedy (formula or function)? Thanx in advance ;) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Automatically elliminate duplicates within a spreadsheet?
Thanx a lot - it worked just fine. -- frenchbox ------------------------------------------------------------------------ frenchbox's Profile: http://www.excelforum.com/member.php...o&userid=29271 View this thread: http://www.excelforum.com/showthread...hreadid=489906 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically updating data from another excel spreadsheet | Excel Worksheet Functions | |||
| need to replicate insertting a row from 1 worksheet into another | Excel Discussion (Misc queries) | |||
| Finding Duplicates | Excel Worksheet Functions | |||
| #REF error on linked spreadsheet | Links and Linking in Excel | |||
| How do I create spreadsheet that automatically updates numbers/va. | Excel Discussion (Misc queries) | |||
Linear Mode
