Sorting averages in Excel.

[ABAP4Life]

I'm sorry about the title but I did not know what to call this post. I have an Excel workbook that is being used to keep track of simple course rankings among users. My company has is putting on an SAP Education weekend and we asked the end-users what courses they would like to attend. Each person ranked the 19 courses from 1-19 and I am putting those rankings in a workbook in order to see what courses need to be taught. Right now the results are just coming in so the workbook is not complete but it does have some information in it. What I want is to be able to input the rankings and have a formula determine the "Average" rankings for each course and then to sort said courses according to the average ranking. I am able to determine the average ranking but I am not able to sort said average. Attached is a zipped version of the workbook. Each sheet is a different department and I have calculated the averages on sheet CFS (just for that sheet). If somebody could tell me how to sort those averages along with the course letters (A-S) I would appreciate it.

Thanks in advanced!

[Bryan Hessey]

I'm sorry about the title but I did not know what to call this post. I have an Excel workbook that is being used to keep track of simple course rankings among users. My company has is putting on an SAP Education weekend and we asked the end-users what courses they would like to attend. Each person ranked the 19 courses from 1-19 and I am putting those rankings in a workbook in order to see what courses need to be taught. Right now the results are just coming in so the workbook is not complete but it does have some information in it. What I want is to be able to input the rankings and have a formula determine the "Average" rankings for each course and then to sort said courses according to the average ranking. I am able to determine the average ranking but I am not able to sort said average. Attached is a zipped version of the workbook. Each sheet is a different department and I have calculated the averages on sheet CFS (just for that sheet). If somebody could tell me how to sort those averages along with the course letters (A-S) I would appreciate it.

Thanks in advanced!

Did you mean as per the attached?

if so, select columns G to Y, set the sort options to Sort Left to Right and use Row 10

hth
---