+ Reply to Thread
Results 1 to 2 of 2

Highlight Approximate Match in a column (Not exact Match)

  1. #1
    Registered User
    Join Date
    08-16-2013
    Location
    India
    MS-Off Ver
    Office 365 (Monthly Targeted Channel)
    Posts
    26

    Highlight Approximate Match in a column (Not exact Match)

    I have a list of names in column A. I want to highlight the names if it matches 70%

    For example :

    1. Ram Kumar
    2. Rama Kumar
    3. Akash Tripathi
    4. Aakash Tripathi
    5. Mr. Ram Kumar
    6. Akash M Tripathi
    7. Ram Kumar

    Excel conditional formatting finds Row 1 & 7 as exact match, but it can't help with others. Where as Row 1,2,5 & 7 are actually same person. I need formula for Conditional Formatting.

    Somehow, I found one formula but its not working in my case.

    =IF(A1<>"",COUNTIF($A$1:$A$23,"*"&MID(A1,1,INT(LEN(A1)*0.7))&"*")>1)

    Excel Fuzzy Lookup thing is not for me, Because I want conditional formatting formula, which can highlight cell instantly after entering data. This sheet gets regular entries from various persons.

    Thanks.

  2. #2
    Registered User
    Join Date
    08-16-2013
    Location
    India
    MS-Off Ver
    Office 365 (Monthly Targeted Channel)
    Posts
    26

    Re: Highlight Approximate Match in a column (Not exact Match)

    dump, Anyone ?

+ 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] Count Unique Values with Partial Match one column exact match another column
    By carsto in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 07-30-2019, 09:56 AM
  2. Index Match with multiple criteria - 1 exact, 1 approximate
    By sittinontop in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-30-2017, 05:38 PM
  3. Replies: 4
    Last Post: 03-31-2017, 05:49 AM
  4. [SOLVED] index match with approximate and exact lookups
    By jhuvba in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-10-2016, 12:56 PM
  5. [SOLVED] vba to replace string from exact match list by searching approximate value
    By johnlara in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-18-2015, 10:12 AM
  6. match approximate 2 column
    By alaaabouelazm in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-24-2015, 12:08 PM
  7. Replies: 4
    Last Post: 12-14-2009, 03:21 PM

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