Sorting/Filtering Info

  • Thread starter Thread starter KErin
  • Start date Start date
K

KErin

Hi,
I have a 1500-row mailing list that includes the guests' account numbers in
one of the columns. Some guests have multiple addresses (work, home, etc) so
for that guest, there are multiple rows but the same account number.
Is there a way to sort and/or filter that will identify all of the multiple
account numbers without having to go through the entire list by hand?
I tried advance filter for unique records, hoping that if I pulled out all
of the people who didn't have multiple addresses it would at least help
narrow the records down, but nothing happened at all when I used that filter.

Thanks for any help you can provide!
 
KErin,

You can 'tag' all of the rows with duplicate data. if the account number is
in Col D., insert a column and insert this formula there (assuming your data
starts in the 2nd row):
=IF(COUNTIF(D$2:D$1000,D2)>1,â€Duplicatedâ€,"Not a Duplicate")

Then sort on the 'duplicate' column to find all of the duplicate acct numbers.

hope that helps.
 
Back
Top