Group and sort on two columns
I want to group by number then sort by amount descending.
sample: 111111 50.00 222222 100.00 111111 50.00 222222 50.00 I want it to sort this way: 222222 100.00 222222 50.00 222222 total 150.00 111111 50.00 111111 50.00 111111 total 100.00 |
Group and sort on two columns
"Marianne" wrote in message ... I want to group by number then sort by amount descending. sample: 111111 50.00 222222 100.00 111111 50.00 222222 50.00 I want it to sort this way: 222222 100.00 222222 50.00 222222 total 150.00 111111 50.00 111111 50.00 111111 total 100.00 OK. You should do it, then. What have you tried so far? |
All times are GMT +1. The time now is 08:44 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com