| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
how do i filter multiple columns
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? |
|
#2
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I've put data to columns - counted - need dropdown filter | Excel Discussion (Misc queries) | |||
| Multiple columns in stack graph | Charts and Charting in Excel | |||
| drop down list multiple columns | Excel Discussion (Misc queries) | |||
| Pivot Table combining multiple columns | Excel Discussion (Misc queries) | |||
| HOW TO MATCH MULTIPLE COLUMNS WITH OR WITHOUT GAPS IN eXCEL ? | Excel Worksheet Functions | |||
Hybrid Mode
