Hi All
Need your help.
This is how my data looks like....
A1 B1 C1 D1
Bob Called Answered Recieved
Jimmy Answered Called
LEE Received Answered
What I need is a column that says
IF A1 had 3 consecutive "interactions" then say "Multiple" (regardless of what it was,couldve been called, answered or received"
but also and if statement to show for 2 consecutives "double"
and also an if statment for 1 "single"
Any idea? Thanks!
Bookmarks