Need help count repeat order frequency

[andreaschrist96]

so here's my problem, i want to count how many times one customer make repeat order in last 6 months, but in 1 month, if they make more than one repeat order i only want to count it once. so in my excel i can see how many customer go to my shop in only 1 month, 2 month, 3 month, etc.

here's the example, customer A go to my shop in month 1 , 3 , and 4
customer B go to my shop in month 4 , 5 , and 6
customer C go to my shop in month 1
customer D go to my shop in month 1 , and 6

so in my excel i need formula to count and the result i needed is

1x = 1
2x = 1
3x = 2
4x = 0
5x = 0
6x = 0

because i only need last 6 month

[PaulM100]

Welcome to the forum!

Please upload a sample with desired results in it and the logic behind as your post doesn't explain it. To post a WORKBOOK. Nobody wants to type data from a picture or paste text from your post into a spreadsheet as a prelude to helping. To attach a file, click Go Advanced below the text edit window, scroll down and click the Manage Attachments link, browse to the required file, and then push the Upload button, then Close Window to return to your post. (The "paper clip" icon for attachments is not currently working.)