How to delete rows with a unique value in given column- ? formula and/or sort?

I have three fields in my worksheet:

1. Customer ID Nbr
2. Product Ordered
3. Order Date

I would like to delete rows for all customers who have only one record (so only one Customer ID Nbr) in this worksheet. The end result would be to retain the Customer ID Nbr, the Product Ordered, and the Order Date ONLY for those customers who have placed more than one order.

Is there a fomula and/or sort that would easily accomplish this?

Thanks!

You could use a countif to count the entries for each customer
then select all the customers who have one purchase
then delete them.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Thanks for your response. Without seeing the data, can you tell me what "criteria" should be used within the Countif function in order to count the number of entries for each customer (field name: Customer ID Nbr).

Thank you for your responses! I was having some problems with CountIf but found that I was able to use Conditional Formatting to color duplicate Customer ID Nbrs and then sort that field by cell color in order to separate out the records with unique Customer ID Nbr in one block and easily delete them.