how do i filter multiple columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count entries in the column translating to minutes. 5
Sorting 1
How Do I Find Different Values In A String? 2
column A matches f places the value from g in column b what funct 2
Excel Formular help 1
Multiple Instances in a Column 1
Excel Concatenate with line breaks but ignore blank cells 3
Count columns that meet criterias 3

Back
Top