Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 5th 08, 09:27 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 336
Default 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

  #2   Report Post  
Old December 5th 08, 09:36 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 336
Default 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

  #3   Report Post  
Old December 5th 08, 09:46 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2008
Posts: 83
Default 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)

  #4   Report Post  
Old December 5th 08, 09:48 AM posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 9,221
Default 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.


  #5   Report Post  
Old December 5th 08, 09:57 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 336
Default 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)




  #6   Report Post  
Old December 5th 08, 10:07 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2008
Posts: 83
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel auto-filter does not filter certain columns Eric_NY Excel Discussion (Misc queries) 5 November 29th 08 10:13 AM
Need Excel formula to separate names into columns, with exceptions intuishawn Excel Discussion (Misc queries) 4 August 27th 07 04:31 PM
COUNTIF for criteria in two separate columns (Excel 2003) Mimi Excel Worksheet Functions 5 January 11th 07 09:06 PM
I wish to separate city, state, and zip into 3 separate columns Bob Woolbert Excel Worksheet Functions 1 July 11th 06 05:29 PM
Can I use Excel to match text data from 2 separate columns ? Dan Excel Worksheet Functions 1 September 29th 05 03:51 AM


All times are GMT +1. The time now is 01:02 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017