Google Spreadsheet Post #1822
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Nov-03-2014
post by Surge Protector:
(https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/Ndan0KXBBD4)Sorting a column with an Array formula
I have a very simple evaluation form that ranks people on a scale of 1-4:
And a fairly simple response sheet with a tab that queries the responses =QUERY('Form Responses 1'!C:E,"select * "):
I cannot sort column A on the second tab which has an array formula pulling data from 'Form Responses 1' =ArrayFormula('Form Responses 1'!B:B)
Just looking to rank those being evaluated from highest to lowest…It all blows up on me when I try and sort the data??
Please help !!
-----------------------------------------------------------------------------------------------------------------------------------
