Filter 2 separate columns in Excel
 

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

Filter 2 separate columns in Excel
 

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

Filter 2 separate columns in Excel
 

"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..

--
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)

Filter 2 separate columns in Excel
 

list all A4 drawings with project number 1234

In xl2003
Just Autofilter & choose in sequence, eg:
Go to Paper size col droplist: Choose: A4
This filters all A4 lines

Then go to Project number col droplist, Choose: 1234
to get the subfilter results

(You can also filter 1234 first, then subfilter A4
- should give you identical results)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
---
"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.

Filter 2 separate columns in Excel
 

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..

--
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)

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)