Row sorting question

[Guest]

Hi all,
I have a spreadsheet of almost 7000 rows and 32 columns., set up something
like this:

a 0 0 0 0 2 3 0 4 3
b 1 2 3 0 0 0 3 1 6
c 0 0 1 3 3 5 6 7 2
d 1 2 3 4 0 0 0 0 0
e 0 0 0 3 2 1 4 3 2
f 0 0 0 3 0 1 4 4 5

Does anyone know if there's a way to sort the columns by the number of zeros
that start the row, with the least at the top, so it would look like this:

b 1 2 3 0 0 0 3 1 6
d 1 2 3 4 0 0 0 0 0
c 0 0 1 3 3 5 0 7 2
e 0 0 0 3 0 1 4 3 2
f 0 0 0 3 0 1 4 4 5
a 0 0 0 0 2 3 0 4 3

Thanks a lot!
Jezzica85

 

[Ardus Petus]

You can add a staging column with following formula:
=COUNTIF(B1:J1,0)

and then sort your data on that column

HTH

 

[Dave O]

I got results that matched your desired results by inserting a "helper"
column and entering this formula onto each row:
=C1&D1&E1&F1&G1&H1&I1&J1&K1
This concatenates each series of numbers into a single string. My
formula column was col M; I then sorted then entire row on col M in
descending order.

 

[Guest]

Thanks Dave, that worked great!
Jezzica85