+ Reply to Thread
Results 1 to 2 of 2

Partial Match between addresses and highlighting

  1. #1
    Registered User
    Join Date
    12-09-2015
    Location
    Chicago, Illinois
    MS-Off Ver
    MS Office 2010
    Posts
    19

    Partial Match between addresses and highlighting

    Hi,

    I am trying to match columns that are either exact or partial matches of their given addresses.

    For example
    In Column A (address) as listed
    A1: Bedford Square
    A2: Steeplegate Mall
    A3: 80 Premium Outlets Blvd- STE

    In Column B (address) as listed
    B1: Bedford Sq
    B2: Greenville
    B3: 80 Premium Outlets Boulevard- Suite 48

    Is it possible to be able to highlight cells A1, B1, A3, and B3, since we would consider them as matches??

    Thank you in advance everyone!

  2. #2
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Northeast USA
    MS-Off Ver
    Office 365
    Posts
    2,043

    Re: Partial Match between addresses and highlighting

    Yes, but fuzzy string matching is hard.

    Your question is too difficult for a free help forum.
    Click the [* Add Reputation] Button to thank people for help!
    Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
    Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.

+ 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] INDEX MATCH Multiple Output with Partial Match
    By Ray Storm in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-02-2015, 12:05 AM
  3. Replies: 2
    Last Post: 09-27-2014, 04:34 PM
  4. Matching and highlighting addresses in a address book
    By GioTrevor in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-14-2014, 03:22 PM
  5. Replies: 0
    Last Post: 09-21-2013, 09:03 PM
  6. Match formula Full match vs. Partial
    By StevenH61 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-26-2013, 10:29 AM
  7. Replies: 3
    Last Post: 01-28-2012, 03:41 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