Thursday, April 12, 2018

yogi_How To Handle Field With Mixed Data Type While ORDERing This Field Using QUERY Function

Google Spreadsheet   Post  #2422

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Apr-12-2018
Creating a "Query How To" ... stuck on order by
Hi All,

I'm creating a short and basic 'how to' guide for beginning query users. Ran into an unexpected issue with 'order by' as it's only working when I have a 'where' included. Please see this Sample Workbook, specifically the 'quick reference' tab and the associated number tab #4.

Feel free to add any simple examples if you've found them helpful. I'm trying to think of the basic ones that are used frequently when beginning to work with query. Maybe add an average or something?

Thank you!
Kristi