Hi There,
Would someone please help me with the following?
Over the last few weeks, I have sent multiple SMSs to customers asking them to register into one of our events. I have the list of mobile numbers listed (please see attached - a sample).
How do I go about filtering the list of users who have received multiple SMSs? In the Sample.xlsx file, you will see that the number 12345678 appears on all 4 columns and 33334444 appearing twice (Columns B and C). What is the formula for calculating if a person received multiple SMSs?
Please help. I am at my wit's end.
Thank you.
Kind regards,
Ram
Bookmarks