Deleting rows

[PBANKS]

I can not come up with something for this. I have books in column C and years in column H. I need to delete all books with 2010-2 and 2010-3 and all rows that have years pertaining to that book. I just can not figure it out.

[JBeaucaire]

Put this formula in J7 and then copy down to J6203:
=IF(A7="",J6,J6+1)

Put this in K6:
Key

Put this in K7 then copy down to K6203:
=IF(OR(H7={"2010-2","2010-3"},AND(J7=J6,K6="bad")),"bad","Good")

Highlight K6:K6203

Select Data > Filter > Autfilter

Filter K6 for "Bad"

Highlight all visible rows and delete them.

Data > Filter > Autofilter to turn it off and you're left with the rest.

[PBANKS]

I could not get it to run, but I did come up with this "FINALLY"

Please Login or Register  to view this content.