Multiple sort criteria
 

My s/s contains approx 20 columns that I want to sort.
Each cell either has 1 or 0. I want to sort all these columns so that the
rows with the least 1's in the 20 columns is first and the row with the most
1's in the 20 columns is at the end.

I have tried doing up to 5 column sorts but after that excel seems to lose
the first sort.
Does Excel have a maximum number of times that you can sort? If so is there
another way I can do this?

Thanks - pj

Multiple sort criteria
 

Hi PJ

Add a column (21) with this formula
=COUNTIF(A1:T1,1)
Copy down this formula and sort on column 21



--
Regards Ron de Bruin
http://www.rondebruin.nl



"pj" wrote in message ...
My s/s contains approx 20 columns that I want to sort.
Each cell either has 1 or 0. I want to sort all these columns so that the
rows with the least 1's in the 20 columns is first and the row with the most
1's in the 20 columns is at the end.

I have tried doing up to 5 column sorts but after that excel seems to lose
the first sort.
Does Excel have a maximum number of times that you can sort? If so is there
another way I can do this?

Thanks - pj