I have a large master list of all the transactions of my company that also includes the customer's name. Is there a formula, or method, whereby I can create a separate worksheet that lists out each unique customer and their total purchases?
For example:
My master list shows John has made 8 different transactions in the last 6 months. It also shows Sally, Amanda, James and Chris each making 5 transactions each.
I want to create a summary worksheet that shows my top 5 customers and how much they spent.
Does that make sense?