| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Filter 2 separate columns in Excel
"Martin" wrote in message
... Cheers Gordon, that sorted it! "Gordon" wrote: "Martin" wrote in message ... Forgot to mention, I'm using Excel 2007.. "Martin" wrote: Can I filter more than one column in one worksheet? For example, if I have paper size in one column and project number in another, I need to list all A4 drawings with project number 1234. As far as I can see it's only possible to have one filter per worksheet. Any help would be appreciated. Thanks Martin No you can filter on two columns - it seems that you need to select ALL the columns in the list.. YW! -- Asking a question? Please tell us the version of the application you are asking about, your OS, Service Pack level and the FULL contents of any error message(s) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel auto-filter does not filter certain columns | Excel Discussion (Misc queries) | |||
| Need Excel formula to separate names into columns, with exceptions | Excel Discussion (Misc queries) | |||
| COUNTIF for criteria in two separate columns (Excel 2003) | Excel Worksheet Functions | |||
| I wish to separate city, state, and zip into 3 separate columns | Excel Worksheet Functions | |||
| Can I use Excel to match text data from 2 separate columns ? | Excel Worksheet Functions | |||
![Gordon[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
