Hi All I would like to find matching values using different dimensions and count finding repeat customer
If Basecustomer Id match
Phone Number (Mobile OR Landline)
Email ignoring any email with the following words ( 'noemail%' , 'nomail%' )
(First name + Last name + Postcode Match)
How do I create a calculation that will consider all the above conditions?
I am just counting for each year say 2000 -2018
How many previous were matching with the above conditons ...
do you have any sample workbook to share so that will be easier to address your issue?