I have data that shows the all the store visits made by each person with their timestamps and looks like this:
I need a formula that will work out the following in two separate columns:
- A visitor who has made at least 1 visit in a 6 month period
- A visitor who has made 6 or more visits...