Monday, November 3, 2014

yogi_Compute Row By Row Average Score By Name Sorted In Descending Order From Data In Sheet 'Form Responses 1'

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