+ Reply to Thread
Results 1 to 7 of 7

Highlight Partial Match using function

  1. #1
    Registered User
    Join Date
    06-26-2012
    Location
    1.50 groerpo
    MS-Off Ver
    Excel 2007
    Posts
    3

    Question Highlight Partial Match using function

    Hello All,

    I am having a excel where I have data like below

    ABC Corp
    ABC Corp LLC
    ABC Corp LLC Ltd
    XYZ Solutions
    XYZ Solution
    XYZ Solutions Ltd
    XYZ Solutions Corp Ltd

    I need to remove all the partial duplicates and have only unique value like the below

    ABC Corp LLC Ltd
    XYZ Solutions Corp Ltd

    I am just a beginner and help me to sort out this.
    Attached Files Attached Files
    Last edited by sivagopi; 01-14-2015 at 01:45 PM.

  2. #2
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,914

    Re: Highlight Partial Match using function

    Attach a sample file file with expected result
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  3. #3
    Registered User
    Join Date
    06-26-2012
    Location
    1.50 groerpo
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Highlight Partial Match using function

    Hi, I have attached the spreadsheet for your reference. Please revert if I am not clear.
    Attached Files Attached Files

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,053

    Re: Highlight Partial Match using function

    It's not clear what you want... but does this look like what you wanted? i suspect not, but you never know!!

    (I posted this BEFORE I saw your sheet at post 3)
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  5. #5
    Registered User
    Join Date
    06-26-2012
    Location
    1.50 groerpo
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Highlight Partial Match using function

    Hi Glenn,

    First I would thank to help my issues.

    I have updated the question with what exactly I need and uploaded the sheet for your reference.

  6. #6
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,914

    Re: Highlight Partial Match using function

    A18=IFERROR(INDEX($A$1:$A$12,SMALL(INDEX((LEFT($A$5:$A$12,SEARCH(" ",SUBSTITUTE(SUBSTITUTE($A$5:$A$12,","," "),"-"," ")&" ")-1)=LEFT($A$6:$A$13,SEARCH(" ",SUBSTITUTE(SUBSTITUTE($A$5:$A$12,","," "),"-"," ")&" ")-1))*10^10+ROW($A$5:$A$12),0),ROW($A1))),"")
    Try this and copy towards down
    Attached Files Attached Files

  7. #7
    Forum Expert sourabhg98's Avatar
    Join Date
    10-22-2014
    Location
    New Delhi, India
    MS-Off Ver
    Excel 2007, 2013
    Posts
    1,899

    Re: Highlight Partial Match using function

    Hello
    I have figured out some formulas....
    Now the match the first word with all others .....like ABC is the first word ....so it will see all other values having first word as "ABC" and see which word has the maximum length and returns that....like "ABC Corp LLC Ltd" has the max length, so it will return that.....
    Hope it helps....
    Regards
    Sourabh
    Attached Files Attached Files

+ 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. [SOLVED] Find partial match between two columns and highlight cells that match
    By TomToms in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-18-2019, 01:07 PM
  2. [SOLVED] Function based on Partial Match Range
    By wkleijn in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-26-2014, 05:16 PM
  3. [SOLVED] Way to highlight cell when searching for a partial value / text?
    By MrGezus in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-29-2014, 11:23 AM
  4. Color/Highlight the Partial Content of a Cell
    By K.Raja in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-01-2014, 07:51 AM
  5. Macro help?? highlight partial rows?
    By CABOS in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-16-2008, 06:00 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1