Home |
Search |
Today's Posts |
#1
|
|||
|
|||
find duplicate cells in Excel
I need to eliminate duplicate addresses in a mailing list. I only want to
send to one letter to "family" at each address. I have assigned the last name column to a range called "Lname" and the full address including city/st/zip to a range called "Addr". What would be the best formula to review 60000+ records for duplicate last names at the same address? |
#2
|
|||
|
|||
Shawn,
I think Chip Pearson has some stuff on this at his site. www.cpearson.com. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "shawneyv" wrote in message ... I need to eliminate duplicate addresses in a mailing list. I only want to send to one letter to "family" at each address. I have assigned the last name column to a range called "Lname" and the full address including city/st/zip to a range called "Addr". What would be the best formula to review 60000+ records for duplicate last names at the same address? |
#3
|
|||
|
|||
See:
http://www.cpearson.com/excel/duplic...ghlightingDupl icates HTH Jason Atlanta, GA -----Original Message----- I need to eliminate duplicate addresses in a mailing list. I only want to send to one letter to "family" at each address. I have assigned the last name column to a range called "Lname" and the full address including city/st/zip to a range called "Addr". What would be the best formula to review 60000+ records for duplicate last names at the same address? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro to Find Replace in Excel | Excel Discussion (Misc queries) | |||
Finding duplicate records in Excel | Excel Discussion (Misc queries) | |||
Microsoft Excel could not find anything to print | Excel Discussion (Misc queries) | |||
linking cells in Excel 2003. How to not truncate to 255 characters. | Excel Discussion (Misc queries) | |||
Duplicate records in Excel | Excel Discussion (Misc queries) |