B
Bowmah
I have a duplicate entry problem. It's not a typical one and I can'
figure it out. Here goes:
I have a sheet with 10 columns of data.
Email and Price Total are the 2 relevant ones.
This sheet is a file of all orders since the last 4 months. Each order
= 1 row of data. I want to measure lifetime value of a customer so the
only way to do that is to measure how many times a unique email
ordered and how much the grand total of all their orders were.
How can I do this in Excel. I am almost sure it can be onde jujst that
I can't do it. I tried Advance Filter but can't figure out how to
filter based on an email.
Any help would be appreciated.
Bowmah
figure it out. Here goes:
I have a sheet with 10 columns of data.
Email and Price Total are the 2 relevant ones.
This sheet is a file of all orders since the last 4 months. Each order
= 1 row of data. I want to measure lifetime value of a customer so the
only way to do that is to measure how many times a unique email
ordered and how much the grand total of all their orders were.
How can I do this in Excel. I am almost sure it can be onde jujst that
I can't do it. I tried Advance Filter but can't figure out how to
filter based on an email.
Any help would be appreciated.
Bowmah