Multiple sort criteria

P

pj

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
 
R

Ron de Bruin

Hi PJ

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