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     www.energyefficientbuild.com.

user listofideas said:

How to do a query, select certain columns and get it sorted?

Hi

Here's a sample spreadsheet: 

https://docs.google.com/spreadsheet/ccc?key=0ApO_59TcG2RpdG1OdmJfZlZiRHdrYUZZZ1hIR3c5elE#gid=0 

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

Thanks!

----

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