Say we have values in cols A thru Y. We are interested in zeros. In Z2 enter:

=IF(COUNTIF(A2:Y2,0)=25,25,IF(COUNTIF(A2:Y2,0)=0,0 ,1)) and copy down

Set the AutoFilter for column Z.

To see rows with all zeros, filter for 25
To see rows no no zeros, filter for 0
TO see rows with some zeros, set the filter for 1
--
Gary''s Student - gsnu200903


"Gazz_85" wrote:

I have a data table and in different columns a record may have a 0 in it. I
want to be able to write a simple line of code which hides any records with a
0 in it any were in its record.

any help??????