You could also use a formula like:

=countif(a2:d2,1)
and drag down.

Then filter to show everything greater than 0.



Teric506 wrote:

I have a spreadsheet that i am trying to filter. I have tried auto filter but
it is not working. What I have is a coumn with a part number and then 4
columns with other numbers. I am trying to pull out the part numbers that
have a 1 in any of the other 4 columns. below is a sample of my spreadsheet.
A number 1 may show up in column A for one part number and a number 1 may
show up in column C for another part number. I need to be able to put all of
the part numbers that have 1 in one of those columns together and so on. This
is for cycle counts for inventory so the 4 columns represent the week that
those part numbers need to be counted.

wk wk wk wk part #
1 13 26 39 19080
2 14 27 40 100039
4 16 29 1 101007

Any help would be great. I am beating my head against a wall here.

--

Dave Peterson