Results 1 to 2 of 2

Finding Common Items - Comma separated

Threaded View

  1. 11-22-2021, 02:53 PM #1
    Prascena
    Prascena is offline
    Registered User
    Join Date
    03-01-2018
    Location
    India
    MS-Off Ver
    2010
    Posts
    33

    Finding Common Items - Comma separated

    Hello,

    Can anyone help me with formula to get the Output (Column C in attached excel)

    Column A and Column B have some numbers (Alpha Numeric) separated by comma. If they have any common number, then I need Column C value to be "Yes" and if not I need value to be "No".

    Can anyone help with this?

    Thank you in advance.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. formula to find common numbers in column. multiple values separated by comma in each cell
    By gianetics in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-30-2021, 03:19 PM
  2. Counting the common unique values between two comma-separated lists
    By max333 in forum Excel General
    Replies: 8
    Last Post: 07-20-2020, 03:25 PM
  3. [SOLVED] How do I SUM the values of comma separated items in a single Cell.
    By nathanledbetter in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2019, 02:41 PM
  4. [SOLVED] Copying a row down, transposing a list of comma separated items into those new rows
    By HorsePop in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-08-2013, 07:10 AM
  5. Search for comma-separated list of items
    By BBerndsen in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-15-2013, 11:16 AM
  6. [SOLVED] VBA- Selecting multiple items separated by comma
    By jewellove in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-30-2013, 01:46 AM
  7. Help with counting multiple items in a cell separated by a comma
    By excelnoobies in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-11-2012, 02:43 AM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1