Relative newB, here is my problem summarized,

In this simple example I have 4 people with different orders. I want to sort by order total for instance, or alphabetical or whatever. All I need is for Mike's purchases to stay below his name and Chris's purchases, and Amy's etc... When I try grouping it does not work. The sort will sort all rows individually.

thank you


gatesbless

Attached Files

SimpleExample - Copy.xlsx (8.1 KB, 11 views)

The problem is the way your data is formatted. Sorting is done by columns. Your name column is seen as some names and then some blank cells. If you had a name on every line you could sort by name and then totals and it would keep the names together and then sort the totals either high to low however you choose while keeping the names together.