Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel - Advanced Sort
- Thread starter ColinN
- Start date
Can you give more of an explanation - including application (I assume excel), examples of the type of data you need sorting and what you need as an end result
Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde
Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde
- Thread starter
- #3
Thanks Geoff! This is an excel application. We are compiling results of a questionaire. The answers to each question can be betwen 1 and 4. 1 being poor and 4 being excellent.
We need to create a graph which groups all the numbers together individually. For example, all of the 2s will be grouped together and then counted. We must also do this for the remaining numbers (1,3,4) We need to show how many of each answer is given and show the results in a chart.
Your help is greatly appreciated.
We need to create a graph which groups all the numbers together individually. For example, all of the 2s will be grouped together and then counted. We must also do this for the remaining numbers (1,3,4) We need to show how many of each answer is given and show the results in a chart.
Your help is greatly appreciated.
Well, this souds like a prime candidate for a pivottable
If all your mumbers are whole numbers then just slap a pivot table on the whole lot of data
Put "Question" as the page field, Answer (1 to 4) as the ROW field and COUNT of Answer as the VALUE field
You can then show overall, how may 1s, 2s etc and by question - by using the drop down functionality on the page field
Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde
If all your mumbers are whole numbers then just slap a pivot table on the whole lot of data
Put "Question" as the page field, Answer (1 to 4) as the ROW field and COUNT of Answer as the VALUE field
You can then show overall, how may 1s, 2s etc and by question - by using the drop down functionality on the page field
Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde
- Status