Thursday, July 5, 2012

yogi_Extract Specified Columns From A Given Range Based On Multiple Criteria

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #609   Jul 5, 2012

user listofideas said:

How to do a query, select certain columns and get it sorted?
Here's a sample spreadsheet: 
1) I need a formula for Sheet6 to contain columns A,B,D where D is 'Bus' and have the sheet sorted alphabetically according to column A
then user tomaswk19 said:
Hi Yogi,
Is it possible to do a function where I add an "and" or "or" for the "where" part...
e.g. where D='Bus' or where B='Yes'
e.g. where D='Bus' and where B='Yes'
I have assumed tomaswk19 mean column C when he refers to column B -- with that following is a solution to the problem