If I understand you correct than you want filter on
the part number column ?

Have you try Data AutoFilter
See Excel Help for details

If you need more help post back

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Teric506" wrote in message ...
I am trying to filter morethan one colums. I have 4 columns with differents
numbers. I need to pull out all of the number ones and coresponde to a part
number. my spead sheet kind of looks like this.

1 13 32 52 51623
7 28 12 1 91232
3 24 10 12 22222

The part number is the one all the way on the right. What I am trying to do
is pull out all the ones for each part number. Any ideas?