Hi,

It's a hard one to explain so I've attached a easy to understand example.

Basically I want to be able to paste my sales data into a spreadsheet and it summarizes it for me. So I can see the total number or orders, the individual totals and then from that I can work out average baskets etc.

I've been racking my brain on how I can do this but coming up blank. Anyone able to help?

Any help really appreciated.

Thanks,
BenExampleSalesReport.xlsx