Apply autofilters and select the value you want to remove in the
pull-down list on the appropriate column. Then highlight all the
visible rows and Edit | Delete Row. When you select "All" in the filter
pull-down you will be left with the records you want.

Hope this helps.

Pete