Monday, June 10, 2013

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

No comments:

Post a Comment