Need help sorting data in columns that will sort by number of Xs
Good morning and thanks for clicking!
I have a workbook with 100+ columns that are headed by a person's name. Below, there are Xs that mark whether or not that particular person answered a polling question during a training session. Each X is on its own row and there can be up to 16 Xs under each named column.
What I want to do is sort this data to show me how many each person answered. I want the people with the most Xs on the left and then the people with the least on the right. I don't need Excel to tell me a numerical value of each person's earned Xs but it is okay if it does.
Please reply back if I can offer any further clarification. I've attached a sample workbook to make my request a little more clear. I have two tabs on the sample worksheet - one with what I have and one with what I want. I did the "What I Want" tab by hand but I would not be able to do that with the type of large group that I will actually be working with.
I really appreciate any and all help. Have a great day everyone!
FYI: I'm using Excel 2007 and working on a PC.
|