Duplicate cells
 

nLooking for a way to delete all but one row that contains one duplicate
cell. In other words I have a list of names and addresses. Several of the
people are at the same address. I only want one name for each address and it
doesn't matter which name is used for that address. Any ideas?

Casey

Duplicate cells
 

Say your addresses are in column B.

Then insert a new column C and put this in C1:
=countif($b$1:b1,b1)
and drag down that column

You'll see a 1 for the first address in the list. And each additional address
will be incremented by 1 (1, 2, 3, ...)

Then select column C and apply data|filter|autofilter

Filter to show the cells that are greater than 1.

Delete those visible rows.

Be careful.

If you have an address:
123 Main Street
In Chicago, you don't want to delete the records with
123 Main Street
in New York.



cdavis82 wrote:

nLooking for a way to delete all but one row that contains one duplicate
cell. In other words I have a list of names and addresses. Several of the
people are at the same address. I only want one name for each address and it
doesn't matter which name is used for that address. Any ideas?

Casey

--

Dave Peterson