Results 1 to 6 of 6

Search for best match with strings

Threaded View

moosmahna Search for best match with... 11-22-2016, 03:01 AM
6StringJazzer Re: Search for best match... 11-22-2016, 02:34 PM
moosmahna Re: Search for best match... 11-22-2016, 03:20 PM
JOHN H. DAVIS Re: Search for best match... 11-22-2016, 03:59 PM
moosmahna Re: Search for best match... 11-23-2016, 03:24 AM
moosmahna Re: Search for best match... 11-23-2016, 03:25 AM
  1. #1
    Forum Contributor
    Join Date
    06-05-2013
    Location
    Austria
    MS-Off Ver
    Excel 2016
    Posts
    169

    Search for best match with strings

    Hy everyone,

    I was looking for AddIns and macros to find a way to search and find the best match with strings. But no luck. Can you please help me?
    In column A are different strings. Take the first (A2) and search for the best result that matches in Column E. Then copy the best result after searching to B2
    and show the percentage of matching. Then take A3 and do the same again.
    I guess this is a big thing to do, but thanks for your help.

    Kind Regards
    Roman
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Match different long strings with an array of short, summarizing strings
    By FKemps in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-24-2015, 12:55 AM
  2. [SOLVED] search for parts of strings in another list of strings
    By marioroter in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-17-2013, 12:28 PM
  3. excel formula to search Multiple strings in several columns and return strings
    By krratna123 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-13-2013, 11:20 AM
  4. Replies: 1
    Last Post: 08-13-2013, 08:32 AM
  5. Truncate text strings using LEFT and FIND/SEARCH for multiple search terms
    By ngdoherty in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-17-2013, 07:51 PM
  6. [SOLVED] loop to match if shorter strings appears in longer strings
    By mcdermott2 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-19-2012, 08:07 PM
  7. Trying to create a macro to match up search strings and variations in two columns....
    By beepbeep27 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-02-2012, 05:43 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