Advanced Filter

Giganews Newsgroups
Subject: Advanced Filter
Posted by:  anandmr65 (anandmr65.28wyrm_1149485101.0417@excelforum-nospam.com)
Date: Mon, 5 Jun 2006

Hi
I have some 2000 rows and about 15 columns in a data sheet. I would
like to filter the data based on the conditions in 4 columns. the
conditions between columns is 'AND' and condition for rows is "OR".
Could anybody help me how to set the criteria range.

For ex:

Column A    Column B    Column C      Column D
X                  A              P                I
Y                  B              Q                J
Z                  C              R
D
E

The above show the different filter conditions I require. The filter
should satis fy Column A "And" Column B AND Column C AND  Column D.
And for the rows it should filter on X or Y OR Z in column A , A OR B
OR C OR D OR E in column B and so on.

Can we put this table and selct the entire range for criteria range and
do a advanced filter?. It is not working. So I request you to help me on
this.

Thanks in advance for your help.

Regards
Anand

--
anandmr65
------------------------------------------------------------------------
anandmr65's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=30728
View this thread:http://www.excelforum.com/showthread.php?threadid=548449

Replies