Pulling out records that occur more than 5 times

**typingturtle** · 07-23-2019, 11:24 AM

Greetings Everyone,

I have a list of orders received from clients within a specific time period. I have been asked to pull the clients that have placed more than 5 orders in that time period. I know how to pull those that have ordered at least twice using highlight duplicates, can you think of a way I can pull those that have ordered 5 or more? You can see there are duplicate records even for 1 order as we are trying to figure out how many orders we have that are missing information, but dont wish to address those that order infrequently. I appreciate any guidance you have.
Clients with 5 or more orders.jpg

Thank you,
Typingturtle

**FDibbins** · 07-24-2019, 12:02 AM

Hi, welcome to the forum

I would probably just use a helper column, use a COUNTIF in that column, then filter on all values >=5

If you have a problem doing this, upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like, and I will help you through it.