Deleting rows based on a condition

[Guest]

May I ask how to delete all rows in a table, where the contents of Col. D =
Major? This would leave all rows where col. D = Minor, which is what I want
to work with?
Thanks.

 

[Frank Kabel]

Hi
see:
http://www.xldynamic.com/source/xld.Deleting.html

or apply a filer ('data - Filter - Autofilter') and delete all filtered
rows

 

[Myrna Larson]

I would just use AutoFilter to display rows where D = Major. Then delete them.

On Tue, 12 Oct 2004 13:05:05 -0700, "Randy Williams" <Randy