deleting duplicate cells

[billrebels4]

I am back again... Thanks to everyone's help here last time, I was able
to finish all my work and do it correctly.

Ken- I asked last time i was here about deleting duplicate cells. Some
of the names(address, etc) are repeated in my sheet. I want to delete
the extra cell of the people who are in here twice. Not jus the cell
but their record, name, address, city, state zip when they are in their
twice so that they will only be listed once.

You told me how to do this once but i cant find where it is on the
board. Thanks for all the help.... BR4

 

[Jason Morin]

Here's one of several ways:

1. Assuming the name is in column A, put this in row 2 of
an open column and copy down:
=IF(COUNTIF($A$2:A2,A2)>1,"Ken",0)
2. Select this column and press F5.
3. Click Special > Formulas and uncheck everything under
Formulas except "Text".
4. Press <Ctrl><->.
5. Select "entire row".

HTH
Jason
Atlanta, GA

 

[Ken Wright]

Hi Bill - You are probably reading this reply in ExcelForum, so click on the
Search icon at the top right of the sheet once you have clicked into the
miscellaneous group, and then search for your userid billrebels4, and it will
bring up all the threads you have been involved in, including the one you are
referring to. You can then drill down through each of the answers. Post back
if you don't have any joy

 

[billrebels4]

Ken- Stil no joy. I cant seem to find the correct post.... Bill

 

[Ken Wright]

Here they all are:-

http://www.excelforum.com/search.ph...id=10729&sortby=lastpost&sortorder=descending

Paste this into your browser address bar, but watch for wordwrap