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.

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.

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.

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.