Help with grouped data

[jojo101]

I have an excel sheet showing purchases/receipts. With help from this excel forum I have used the subtotal grouped data function, doing each change at the "store" so I can group the receipts seeing their subtotals. (See attached, example 1 ). Works good, particularly if I have different stores on the same day. (example 1, rows 7 & 9) Problem is that if I have a receipt from the same store but on different days it still groups together. ( example 2, rows 33 & 34) I need to have another subtotal group but not sure how to do it. Help would be appreciated.

[oeldere]

Probably you could use Pivot table for that kind of work.

To be sure add the Original data in the file, without confidential information.

Please also add the expected result in your file.

[Richard Buttrey]

Personally I'd use a Pivot Table - see attached

[Richard Buttrey]

...or see the attached which uses the Sub totalling method