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

john

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.