how do i filter multiple columns

T

Teric506

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?
 
R

Ron de Bruin

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
 
Top