Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Help please!!!
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. |