Hello, I need a formula to identify all Purchasers who bought multiple products on the same date. I have to exclude those users in my frequent buyers list. Please see highlighted cells for an example.
Thank you for anyone's help in advance!


Ophelia

Attached Files

Sample.xlsx (9.9 KB, 13 views)

I suggest the first step is to combine day, month and year into a single date column. A pivot table will then provide a quick reference.