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:

https://docs.google.com/a/ez-registration-nj.com/forms/d/1sJF_l-ClDqb8JgvZ2AdW6FLOC7SXjiuK5WgEsFAWx6c/viewform

And a fairly simple response sheet with a tab that queries the responses =QUERY('Form Responses 1'!C:E,"select * "):

https://docs.google.com/a/ez-registration-nj.com/spreadsheets/d/19cnAIioB6eUw15z_KNHehqET1jw2HAjyhP3D3FYx9ds/edit#gid=714037962

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

-----------------------------------------------------------------------------------------------------------------------------------