I can do this easily in access, but I can not seem to find a way in excel.
I am working on customer account report.

I have columns like below:
Customer name 30day 60days 90days 120days
I want to group all the accounts that have data in the 120day column
together, then 90days, then 60 and so on.

I have tried sorting and that does not work effectively.
1st, the sort feature only allows me to sort on 3 columns. I want to sort
on 7.
2nd, I would like to see all accounts with items in the 120day column at the
top of the page. If the amount in negative, it appears at the bottom of the
report.

Any suggestions?