BloodyBill
New Member
- Joined
- Oct 5, 2020
- Messages
- 33
- 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 one-time (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 one-time (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.)