Hi,

I have a large list of customer transactions to sort through. I need to identify customers which have only had one transaction, and those which have multiple transactions.

Each customer is assigned a unique client code, and each transaction is on a new row with a unique transaction number. I have attached an example spreadsheet.

Customer Transaction Database.xlsx


MY goal is to cut the "one-off" customers out of the main database and analyse them separately to those customer who have transacted multiple times.

If you could help with this that would be great!

Thanks JBM17