Thread: Deleting Rows
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] jimmy@hotmail.com is offline
external usenet poster
 
Posts: 7
Default Deleting Rows

I have a column of information that contains a list of
numbers. some of these numbers are duplicated and i want
to eliminate them. I sorted these numbers and then used
the =AND(H9=H10) to see which were duplicated (represented
as true). Is there a way to just go through and delete
the rows that are marked as true? Thanks a lot