View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tasha Tasha is offline
external usenet poster
 
Posts: 157
Default Deleting rows by specified criteria for duplicates

I have gone through all of the posts looking for an answer to my problem, and
haven't been able to find one yet. Hoping someone can help me???

I have a spreadsheet that contains the following rows:
A-Date of Operation
B-Acct#
C-Type
D-Name
E-Doctor
F-Operation

I have many duplicates. I need to delete only 1 row of the duplicates if
they match in columns A-B and E.

Can someone help me with this? This is a huge spreadsheet and is taking
forever to do it manually. Thanks!!