Identifying and removing singular entries from a list

[JBM17]

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

[Glenn Kennedy]

Try this:

If this isnt quite what you want - shout!

[JBM17]

Hi Glenn,

Thanks, this is perfect! Much appreciated.