sorting two columns at the same time

  • Thread starter Thread starter bullseye
  • Start date Start date
B

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?
 
bullseye said:
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?
Click to expand...

(Column A loses its alphabetical sorting once the sorting with columns B
and C completes.)
 
Hi
Select your range. Click on Data/Sort and make your selections from the
dialog box.

Andy.
 
sorry for the delayed reply.

The Data/Sort function is a step in the right direction but doesn't work
well.
 
Back
Top