deleting duplicate cells

  • Thread starter Thread starter billrebels4
  • Start date Start date
B

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
 
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
 
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 :-)
 
Back
Top