Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can three separate sections of rows be sorted in the same order?
I have an Excel worksheet that is divided into three sections:
1st section: The percentage of people who responded a certain way. 2nd section: The difference between how people responded in previous surveys and the current responses to each question 3rd section: The statistical margin of error for each year of responses to each question. The columns are set up like this: Column A: Symbol used on chart Column B: Question text that data refers to Column C-ZZ: Data for each year the question is answered The three sections are set up the same way, but, with the exception of the symbol for the chart and the question text, the numerical data for each question in each section is different. Having said all that; is there a way to sort the other two sections of data to mimic the first? Currently sorting them separately produces questions that are not in the same order as those in the first section. I hope this isn't too much info, but I sure hope there's a way to do this. Thanks for any help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can three separate sections of rows be sorted in the same order?
Nevermind. I figured out what I was doing wrong!
"Jacquiemal" wrote: I have an Excel worksheet that is divided into three sections: 1st section: The percentage of people who responded a certain way. 2nd section: The difference between how people responded in previous surveys and the current responses to each question 3rd section: The statistical margin of error for each year of responses to each question. The columns are set up like this: Column A: Symbol used on chart Column B: Question text that data refers to Column C-ZZ: Data for each year the question is answered The three sections are set up the same way, but, with the exception of the symbol for the chart and the question text, the numerical data for each question in each section is different. Having said all that; is there a way to sort the other two sections of data to mimic the first? Currently sorting them separately produces questions that are not in the same order as those in the first section. I hope this isn't too much info, but I sure hope there's a way to do this. Thanks for any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
series order - sorted? | Charts and Charting in Excel | |||
Why must the table for Vlookup be sorted in ascending order? | New Users to Excel | |||
my column is sorted in two sections. How do I sort entire column? | Excel Discussion (Misc queries) | |||
my column is sorted in two sections. How do I sort entire column? | Excel Discussion (Misc queries) | |||
Separate area under a curve into two sections. | Charts and Charting in Excel |