Hi,

In cell C1, enter the following formula =A1&B1 and copy down. In cell D1,
use the following formula if(countif($A$1:A1,A1)1,"a",1). Now select
column D and navigate to Edit Go To Special. Click on the Formulas
radio button and check the box for Text (Please remember to keep the other
boxes unchecked). Now all the "a"'s in column D will be highlighted. You
can simply delete all the rows now.

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Kimmie" wrote in message
...
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