I have 3 columns of importance in the same sheet one is acct numbers, the
other is the jobs within each account and the other the sum of jobs the
accnt has. I want to produce a sheet that sorts the account according to how
many jobs they have (descending order) while maintaining the grouping of the
jobs in their perspective account.

wks layout:

acct # | job | sum of jobs |
5 | abc | 1 |
2 | fbk | 2 |
| sdf |
3 | asd | 1 |

VB or a formula is fine withe me. Thanks in advance!

hey, you could try to do a Subtotal, sort it by whichever column is more
important to you.

HTH,
Kevin M

"tresmonos" wrote:

I have 3 columns of importance in the same sheet one is acct numbers, the
other is the jobs within each account and the other the sum of jobs the
accnt has. I want to produce a sheet that sorts the account according to how
many jobs they have (descending order) while maintaining the grouping of the
jobs in their perspective account.

wks layout:

acct # | job | sum of jobs |
5 | abc | 1 |
2 | fbk | 2 |
| sdf |
3 | asd | 1 |

VB or a formula is fine withe me. Thanks in advance!