time purchase
Budget: $30 – $250 USD
time between customer purchases is needed per email. The data will be shows as below as all emails and data are in a row.
data:
Date Amount Email
7/1/2019 80.70 email1
7/5/2019 132.50 email1
7/6/2019 46.75 email1
7/7/2019 32.30 email2
results in a new tab:
1) find all emails from sheet 1 and place it as below
2) calculate days between each purchase, example email1 had 3 purchases:
email 1st to 2nd 2nd to 3rd 3rd to 4th 4th to 5th 5th to 6th 6th to 7th 7th to 8th
email1 4 1
email2 1
3) Same process and add amounts which will be provided.
There are in total 180K of emails.
4) Provide the actual macros/VBA/code at the end of the project.
data:
Date Amount Email
7/1/2019 80.70 email1
7/5/2019 132.50 email1
7/6/2019 46.75 email1
7/7/2019 32.30 email2
results in a new tab:
1) find all emails from sheet 1 and place it as below
2) calculate days between each purchase, example email1 had 3 purchases:
email 1st to 2nd 2nd to 3rd 3rd to 4th 4th to 5th 5th to 6th 6th to 7th 7th to 8th
email1 4 1
email2 1
3) Same process and add amounts which will be provided.
There are in total 180K of emails.
4) Provide the actual macros/VBA/code at the end of the project.