| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel 2007 filter 3 text values at the same time from the same co.
I have a column that has these values AA, AX, AW, RJ, WD, CA, IE, NC
Now I would like to filter AA,AX and IE only. How can I do it with just one step instead of filtering each one separately, copying and pasting onto another worksheet. Please, help |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
excel 2007 filter 3 text values at the same time from the same co.
DataAutofilter then clear "Select All" and select AA, AX, IE
Gord Dibben MS Excel MVP On Tue, 6 Apr 2010 12:25:01 -0700, Ivanka wrote: I have a column that has these values AA, AX, AW, RJ, WD, CA, IE, NC Now I would like to filter AA,AX and IE only. How can I do it with just one step instead of filtering each one separately, copying and pasting onto another worksheet. Please, help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 Paste Values-Text Only (Always) | Excel Discussion (Misc queries) | |||
| DataFilterAuto Filter in excel 2007? | New Users to Excel | |||
| Excel 2007 Auto Filter Filter | Excel Discussion (Misc queries) | |||
| filter rows based on text time | Excel Discussion (Misc queries) | |||
| Retrieve text from filter data in workbook 1 and place values in 2 | Excel Discussion (Misc queries) | |||
Linear Mode
