View Single Post
  #1   Report Post  
gcotterl
 
Posts: n/a
Default Deleting rows containing common data

I have an Excel 2000 spreadsheet with 30,000 rows. The rows look like this:

007-007
68-4611
68-4682
total
007-007
total
007-007
28-4831
68-2454
68-4682
total
007-007
28-4831
68-2454
68-4682
total
007-007
28-4831
68-2454
68-4682
total
007-007
68-4682
total
007-007
68-4682
total


How do I delete the rows containing "total"