| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I make columns independent of each other?
I am using Excel 2007 with survey results and would like to sort them by
question. There are 6 worksheets of data: one per campus with approximately 50 questions in the survey and 40 replies per campus. It is too cumbersome to manually perform all these steps. I have the questions separated by column and the answers are numerical ratings. I would like to sort these answers by column independently without regard for the other columns. I would also like to determine the percentage of those who answered 1, 2, 3, etc. Is there any way to do this? Thanks, teacher2010 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I make headers for columns in which their are 6 columns? | Excel Worksheet Functions | |||
| Make Columns A&B on Sheet2 always equal Sheet1 table columns A&B | Setting up and Configuration of Excel | |||
| Make Columns A&B on Sheet2 always equal Sheet1 table columns A&B | Excel Worksheet Functions | |||
| to convert columns to rows having mulit independent group columns | Excel Worksheet Functions | |||
| How to create independent worksheets using data in columns in a s. | Excel Worksheet Functions | |||
Threaded Mode
