Hi everybody,
we are about to begin to work with simple CRM and have first test export in Excel sheet.
Every line represents a transaction containing branch, email, spending and time of the visit. I would like to make formula which determines if the customer is new or returning. Do anybody have an idea how can I recognize If the email already appeared in the list or not?
Thanks for any suggestion.
Bob
do a countif
in a new column
assuming the data starts in row2 and the email is in column A
=Countif(A:A, A2)>1
if the email exists more than once then you get a TRUE
if its unique then a False
you can use an IF() to add whatever text you would prefer to see
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
It depends what you want to do when you find a returning visitor.
Removing >1 from the end of etaf's formula will tell you how many times any email address is listed rather than just true for repeat visits or false for unique entries.
Or using =MATCH(A2,A:A,0) will give you the row that contains the first entry of you want to compare data, although that would be better done with a pivottable using email addresses as row headings.
Thank you for great tips. I am going to test it and let you know.
Regards,
Bob
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks