Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
search/delete duplicate entries in excel '02?
I have 3 columns and 2000+ rows of data. Is there a way to search and delete
duplicate entries for 1 or more of the columns? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
search/delete duplicate entries in excel '02?
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
search/delete duplicate entries in excel '02?
I'm don't want to have to manually search for duplicate records. I want excel
to do it for me. If there are any duplicates I want it to delete one of them. Cause I'm going to use it for a mail merge and I don't want to send anyone more than one letter. Does that make sense? "Gary Brown" wrote: Find...replace with "" -- HTH, Gary Brown If this post was helpful to you, please select ''YES'' at the bottom of the post. "madpeyjag" wrote: I have 3 columns and 2000+ rows of data. Is there a way to search and delete duplicate entries for 1 or more of the columns? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
search/delete duplicate entries in excel '02?
You can use the techniques on Chip Pearson's site, to mark and delete
the duplicates in the source data: http://www.cpearson.com/excel/duplicat.htm madpeyjag wrote: I'm don't want to have to manually search for duplicate records. I want excel to do it for me. If there are any duplicates I want it to delete one of them. Cause I'm going to use it for a mail merge and I don't want to send anyone more than one letter. Does that make sense? "Gary Brown" wrote: Find...replace with "" -- HTH, Gary Brown om If this post was helpful to you, please select ''YES'' at the bottom of the post. "madpeyjag" wrote: I have 3 columns and 2000+ rows of data. Is there a way to search and delete duplicate entries for 1 or more of the columns? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
excel - removing duplicate entries in spreadsheet | Excel Discussion (Misc queries) | |||
check a list of numbers for duplicate entries in Excel | Excel Discussion (Misc queries) | |||
How do you prevent duplicate entries in an excel spreadsheet? | Excel Discussion (Misc queries) | |||
Duplicate records in Excel | Excel Discussion (Misc queries) |