+ Reply to Thread
Results 1 to 2 of 2

Matching Multiple Columns

  1. #1
    Registered User
    Join Date
    02-25-2018
    Location
    Perth, Australia
    MS-Off Ver
    Excel 2016
    Posts
    1

    Matching Multiple Columns

    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
    Attached Files Attached Files

  2. #2
    Forum Expert leelnich's Avatar
    Join Date
    03-20-2017
    Location
    Delaware, USA
    MS-Off Ver
    Office 2016
    Posts
    2,807

    Re: Matching Multiple Columns

    Hi Ram, welcome to the forum. Paste this in F2 and copy down:
    Please Login or Register  to view this content.
    Row\Col
    A
    B
    C
    D
    E
    F
    1
    SMS Sent on 29-Jan SMS Sent on 2-Feb SMS Sent on 5-Feb SMS Sent on 9-Feb SMS sent >1
    2
    12345678
    12345678
    99998888
    87612349
    12345678
    3
    11112222
    33334444
    77776666
    99998888
    33334444
    4
    22223333
    23232323
    55554444
    12345678
    99998888
    5
    33334444
    45445444
    12345678
    6
    87654321
    46467878
    33334444
    7
    12123434
    8
    98769898
    9
    54785478
    10
    97538642
    11
    19283746
    Last edited by leelnich; 02-26-2018 at 12:46 AM.
    Clicking the Add Reputation star below helpful posts is a great way to show your appreciation.
    Please mark your threads as SOLVED upon conclusion (Thread Tools above Post # 1). - Lee

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 10-16-2013, 12:42 PM
  2. [SOLVED] Matching multiple columns and rows
    By Jafs in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-12-2013, 07:10 AM
  3. Help matching to multiple columns
    By magicacaca in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-15-2012, 06:32 AM
  4. Matching multiple critierion across multiple columns
    By anandvh in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-09-2011, 01:31 AM
  5. Matching multiple columns
    By JMT-Z in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-19-2008, 03:15 PM
  6. Matching multiple columns, summing multiple results
    By DamienC in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-09-2008, 09:36 AM
  7. Matching multiple columns
    By Rothman in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-13-2006, 07:45 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1