MrExcel Publishing
Your One Stop for Excel Tips & Solutions

eliminating duplicate data

Posted by John Niolon on November 19, 2001 5:06 PM

I have a address file with names and addresses in an Excel format... there are about 4000 lines of data with multiple duplicates... is there a way to search and remove duplicates in the address column... or any column for that matter...

thanks in advance


BTW you're dealing with a average excel user not a power user...thanks

Posted by Bob Umlas on November 19, 2001 8:21 PM

Sure -- check out Filter/Advanced filter/ Unique records only option.