| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sorting two columns at the same time
I have a spreadsheet with several related columns and I wish to focus on three of them. Column A gives me an alphabetically sorted column which I wish to sort using columns B and C. I want to sort column B in ascending order, while at the same time sorting column C in descending order and based on this to see what I get in column A. How do I do this? -- If you wish to reply using e-mail, please add a 35 (the number) after bullseye. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sorting two columns at the same time
bullseye wrote:
I have a spreadsheet with several related columns and I wish to focus on three of them. Column A gives me an alphabetically sorted column which I wish to sort using columns B and C. I want to sort column B in ascending order, while at the same time sorting column C in descending order and based on this to see what I get in column A. How do I do this? (Column A loses its alphabetical sorting once the sorting with columns B and C completes.) -- If you wish to reply using e-mail, please add a 35 (the number) after bullseye. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sorting two columns at the same time
Hi
Select your range. Click on Data/Sort and make your selections from the dialog box. Andy. "bullseye" wrote in message ... bullseye wrote: I have a spreadsheet with several related columns and I wish to focus on three of them. Column A gives me an alphabetically sorted column which I wish to sort using columns B and C. I want to sort column B in ascending order, while at the same time sorting column C in descending order and based on this to see what I get in column A. How do I do this? (Column A loses its alphabetical sorting once the sorting with columns B and C completes.) -- If you wish to reply using e-mail, please add a 35 (the number) after bullseye. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sorting two columns at the same time
sorry for the delayed reply. The Data/Sort function is a step in the right direction but doesn't work well. Andy wrote: Hi Select your range. Click on Data/Sort and make your selections from the dialog box. Andy. "bullseye" I have a spreadsheet with several related columns and I wish to focus on three of them. Column A gives me an alphabetically sorted column which I wish to sort using columns B and C. I want to sort column B in ascending order, while at the same time sorting column C in descending order and based on this to see what I get in column A. How do I do this? (Column A loses its alphabetical sorting once the sorting with columns B and C completes.) -- If you wish to reply using e-mail, please add a 35 (the number) after bullseye. -- If you wish to reply using e-mail, please add a 35 (the number) after bullseye. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Column matching - sorting. Fairly hard problem, I think. | Excel Discussion (Misc queries) | |||
| Time Sensitive - Stacked Cluster Columns | Charts and Charting in Excel | |||
| Sorting Columns on HTML file created in Excel | Excel Discussion (Misc queries) | |||
| why does sorting large columns create errors in top selection? | Excel Worksheet Functions | |||
| sorting and getting calculations in other columns use new rows | Excel Discussion (Misc queries) | |||
Linear Mode
