yogi_Extract Data From TestData Sheet Based On Data in Different Columns Meeting Multiple Conditions

                                          Google Spreadsheet   Post  #1238
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jun 10, 2013
user csdoty (http://productforums.google.com/forum/?zx=xfh7zk9qc7v5#!mydiscussions/docs/O42Ieww5M1c)
Combining filters or another solution?

Please help!  Rarely do I need to do more than basics with spreadsheets but now I have a situation that I cannot figure out.

 

In my TestData (All data sheet) I have A through Q columns and 2 through 26 rows of member data (25 with a header row).

 

I want to filter into one sub sheet the following:

 

1) All rows where the data in column I is either "DR N3i" or "DR".  This filter sentence does it. =filter(TestData!A2:Q;(TestData!I2:I=ʺDR N3iʺ)+(TestData!I2:I=ʺDRʺ))

 

2) All rows where the data in column F is "DR" and column I is empty.  This filter sentence does it.  =filter(TestData!A2:Q;(TestData!F2:F=ʺDRʺ),(TestData!I2:I=ʺʺ))

 

3) All rows where the data in column D is "DR" and both column F and column I are empty.  This filter sentence does it.  =filter(TestData!A2:Q;(TestData!D2:D=ʺDRʺ),(TestData!F2:F=ʺʺ),(TestData!I2:I=ʺʺ))

 

I can do each of these three individual filters by themselves.  How do I combine these three filters into one filter sentence to give me a filtered spread sheet giving me the rows where column D is "DR" when in the same row F and I are empty, combined with rows where F is "DR" when in the same row I is empty, combined with rows where I is either "DR N3i" or "DR".

 

I am accessing Google Docs via MS Internet Explorer using a Windows 7 PC.

 

Thanks. 

 

csdoty

---

Thanks Yogi.. I thnk i have it set up so you can access. 

 

https://docs.google.com/spreadsheet/ccc?key=0Avh47g6ww_UAdEhKc0w1TVFhQmJLRDFEa1dqUXhGcHc&usp=sharing

--------------------------------------------------------------------------------------------------------------