Duplicates

[Ugly Girl]

I have two long columns of last names and first names in Excel. I do not
type these names in, they are downloaded from a website after I send them
the information. It is a record of what I have submitted to the site. Is
there any way to sort and find all the duplicate rows in the columns. Right
now I have to scroll through over a thousand names to try to find the
duplicates. Thanks

 

[Bernard Liengme]

Let's assume the columns as A and B and the top row has labels
In C2 enter =A2&B2 to join the names together
In D2 enter =COUNTIF($C$2:$C$6,C2)
Select C22 and double click the fill handle in D2 (solid square in lower
right corner) to copy the formula down to the last row
You will get a series of 1s, and 2s (maybe 3s and 4s)
The 1s are unique records, 2 twos are duplicates, the 3s are triplicates,
etc
You could use Data|Sort and sort on column D to organize these
best wishes

 

[ozgrid.com]

Use AdvancedFilter to create a unique list.
http://www.ozgrid.com/Excel/advanced-filter.htm