+ Reply to Thread
Results 1 to 4 of 4

Help with Excel Formula to get the intersecting codes

  1. 01-11-2022, 06:14 AM #1
    chandramouliarun
    chandramouliarun is offline
    Forum Contributor
    Join Date
    10-18-2016
    Location
    Chicago, USA
    MS-Off Ver
    Office 365
    Posts
    220

    Red face Help with Excel Formula to get the intersecting codes

    Hi All,

    Hope you are doing well!.. I am looking to extract the intersecting codes from two columns of data...Please find the data attached ..Can you please help me here...



    Thanks,
    Arun
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 01-11-2022, 06:38 AM #2
    KOKOSEK
    KOKOSEK is offline
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,742

    Re: Help with Excel Formula to get the intersecting codes

    Hi
    As you've got O365, let use LET function and FILTERXML.


    p.s. for some unknown reason I can't post formula as firewall blocked it, even if I wrapped it into html tags. Please check attached file.
    Attached Files Attached Files
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.
    Reply With QuoteRegister To Reply
  3. 01-11-2022, 09:18 AM #3
    chandramouliarun
    chandramouliarun is offline
    Forum Contributor
    Join Date
    10-18-2016
    Location
    Chicago, USA
    MS-Off Ver
    Office 365
    Posts
    220

    Re: Help with Excel Formula to get the intersecting codes

    Thanks @KOKOSEK !..Really appreciate your help!!...
    Reply With QuoteRegister To Reply
  4. 01-11-2022, 12:20 PM #4
    KOKOSEK
    KOKOSEK is offline
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,742

    Re: Help with Excel Formula to get the intersecting codes

    You welcome.
    Happy to help.
    Thanks for rep.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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. Excel Spreadsheet to solve for the 2 intersection points of 2 intersecting circles
    By clm in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-25-2021, 04:07 PM
  2. [SOLVED] Compare JSON data and splitting into corrected codes, deleted codes and added codes
    By chandramouliarun in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 12-01-2020, 06:46 AM
  3. [SOLVED] Compare JSON data and splitting into corrected codes, deleted codes and added codes
    By chandramouliarun in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-29-2020, 12:06 PM
  4. [SOLVED] Excel formula to color the codes as per given number
    By felixpanganiban in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-14-2020, 03:29 PM
  5. Formula to search table by row & get corresponding column header & intersecting cell.
    By dayala2002 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-30-2017, 08:54 PM
  6. Formula to calculate distance between to post codes in Excel
    By Shazz in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-17-2013, 10:20 AM
  7. Intersecting--Maybe?
    By joone in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-05-2007, 03:40 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