I have data showing the following columns: Customer Name, Date of Visit, Shop (my shop, other shops), Product, Price.

I need to find the customers visiting other shops for the same product in my shop within 14 days.

I tried doing a simple IF(AND,… formula but it doesn’t catch customers who’s jumping from my shop to another and back for various products within a month.

​I have data showing the following columns: Customer Name, Date of Visit, Shop (my shop, other shops), Product, Price. I need to find the customers visiting other shops for the same product in my shop within 14 days. I tried doing a simple IF(AND,… formula but it doesn’t catch customers who’s jumping from my shop to another and back for various products within a month.  Read More

​