How to delete these Certain Rows

[alive15]

Good morning,

I have a sheet in Excel 2010 with over 24000 rows. Each row has info on my part, whether it's "good" or "bad". I want to delete all rows that have "bad" in column C. What's the fastest way to accomplish this?

Thanks!

 

[BAlGaInTl]

Good morning,

I have a sheet in Excel 2010 with over 24000 rows. Each row has info on my part, whether it's "good" or "bad". I want to delete all rows that have "bad" in column C. What's the fastest way to accomplish this?

Thanks!

Do you just need to do this once? Or do you have to repeat it over and over?

 

[alive15]

I have another sheet that needs repeated on, but I already figured out a way, thanks.

 

[alive15]

I sorted the column which divided between good and bad parts, then took all the rows at the bottom which were "bad parts" and deleted them pretty quickly.

 

[BAlGaInTl]

I sorted the column which divided between good and bad parts, then took all the rows at the bottom which were "bad parts" and deleted them pretty quickly.

That's what I was going to suggest if you didn't need to do it a lot.

 

[alive15]

If I had to do it a lot, then how would you go about doing it? Using macro?

 

[BAlGaInTl]

If I had to do it a lot, then how would you go about doing it? Using macro?

Yes.

You could automate the same thing.

 

[PakTam13]

I also need the same thing like this.
My excel daily got almost 500k rows.
I want to delete row 12am (not include date) at column in certain column..

By doing manually ny sorting, filter. It take time..

I hope there macro to fasten my job.
Thanks in advance

 

[Michael M]

@alive15
This macro modified from Rick Rothsteins code will do it very quickly

Sub MM1()
  With Range("C1", Cells(Rows.Count, "C").End(xlUp))
    .Replace "bad", "#N/A", xlWhole, , False, , False, False
    Columns("C").SpecialCells(xlConstants, xlErrors).EntireRow.Delete
  End With
End Sub

 

[alive15]

Thanks! I will check it out later.