Spotting similar data

[Cardinal]

I have 12 columns of number that go a couple of hundred rows deep. The
numbers range from 1 thru 5. Any of the rows that have all 3's are
bogus data and I wish to delete them. Right now I am doing this
manually by scanning down through the spreadsheet. Is there a faster
and easier way to do this? I am using Excel 2003 on an XP machine.
Thanks very much.

 

[Pete_UK]

Put a formula like this in M2 (assuming a header row):

=IF(COUNTIF(A2:L2,3)=12,"Remove","okay")

then copy down. Then apply autofilter to column M and select "Remove"
from the filter pull-down. Highlight all the visible rows while the
filter is active and click on Edit | Delete Rows. Select All in the
filter pull-down, then you can delete column M.

Hope this helps.

Pete

 

[Cardinal]

Just tried it - works slick. Thanks very much.
It made my life a lot easier.

 

[Pete_UK]

Well, we can all do with more time - glad to be of help.

Pete