Use datafilteradvanced filter, select unique records, then copy to another
location
That will give you a list without all the duplicates

--


Regards,


Peo Sjoblom

"Kimmie" wrote in message
...

I did not see a response to this question yet.

"Kimmie" wrote:

Just learned something new with two of the formulas that you
provided....now
how do I delete all rows that are duplicate?

Smith, John
Smith, John
Smith, John
Smith, Robert
Smith, Smith
(Delete all Johns using a similiar spreadsheet layout that you provided
with
putting last name and first name together.)

I cannot thank you enough...I just learned about this helpful site.
Total
lifesaver!

"Kimmie" wrote:

I am working on a spreadsheet which has many different fields. The
first
column is Last Name and the second column is first name. My objective
is to
delete the rows with duplicate names and only keep one of the rows. I
tried
using the following formula but it was only reading the first column
which is
last name. How do I change it to read the first and second column.

For instance,

Smith John
Smith John
Shot, Steve
(Keep only one John Smith and delete the other.)

My Second project which is a little different, is to take this
completed
file (the one that only has John Smith and Steve Shot left and remove
the
duplicates) and compare with another spreadsheet. I was going to add
the
spreadsheet fields to this final spreadsheet and then I will need to
remove
all duplicates. What formula do I need to apply so that I can use the
filter?

Then, I have two projects....one I need to delete the "duplicate" rows
and
the other I need to