BloodyBill
New Member
 Joined
 Oct 5, 2020
 Messages
 24
 Office Version

 365
 Platform

 Windows
I want to find & count people who switched from apples to oranges.
I don't care about peaches, pears or bananas. (I don't care about Customer B who switched from Oranges to Peaches.)
I only want to find (out of tens of thousands of jumbled up transactions involving hundreds of customers buying from a selection of 10 fruits) any and all customers like A and E who were at least onetime (or maybe loyal) apple buyers, but decided to switch to oranges.
What we're looking for is the answer to this question: "We're discontinuing oranges. What current orange buyers can we convince to go back to their old habit of buying apples?"
Thanks for any help! (I can't seem to find the answer anywhere.)
I don't care about peaches, pears or bananas. (I don't care about Customer B who switched from Oranges to Peaches.)
I only want to find (out of tens of thousands of jumbled up transactions involving hundreds of customers buying from a selection of 10 fruits) any and all customers like A and E who were at least onetime (or maybe loyal) apple buyers, but decided to switch to oranges.
What we're looking for is the answer to this question: "We're discontinuing oranges. What current orange buyers can we convince to go back to their old habit of buying apples?"
Thanks for any help! (I can't seem to find the answer anywhere.)