Results 1 to 14 of 14

Partial Match for Group Names

Threaded View

  1. 04-16-2015, 11:12 AM #1
    Saarang84
    Saarang84 is offline
    Valued Forum Contributor Saarang84's Avatar
    Join Date
    02-19-2009
    Location
    Chennai, India
    MS-Off Ver
    XL 2003 to 2010
    Posts
    812

    Partial Match for Group Names

    Hi,

    I've a list of group names in a column in a sheet in Excel. I would need some help to code formulas to identifying the nearest / partial match for these groups.

    Currently, I'm doing vlookup to identify exact group name matches and manually identifying partial matches.
    Once all matching is done, then I use EXACT() function to compare the matching group name obtained using vlookup.

    Can anyone help in matching the strings (identifying partial matches as well) ?
    Refer attached sample worksheet with few examples.

    Let me know if you need any information. Any help would be greatly appreciated.

    Sarang
    Attached Files Attached Files
    If my assistance has helped, there is a reputation icon * on the left hand corner below the post - you can show your appreciation to the user who has helped in resolving your requirement.

    If your requirement has been solved please mark your thread as Solved.
    In the menu bar above the very first post, select Thread Tools, then select "Mark this thread as Solved".

    Kindly use [FORMULA] or [CODE] tags when posting your code.

    Regards,
    Sarang
    Reply With QuoteRegister To Reply
« 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. [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. Formula needed for partial string match as part of index match with multiple criteria
    By Marvelous in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-27-2014, 04:34 PM
  3. Macro| Search 4 partial match then apply IF statement based on blank cell next to match ?
    By axemonkey in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-21-2013, 09:03 PM
  4. removing partial data from a group of cells.
    By tmbowers1016 in forum Excel General
    Replies: 3
    Last Post: 08-29-2013, 02:33 PM
  5. Sort a group of names based on the group total
    By ron2k_1 in forum Excel General
    Replies: 3
    Last Post: 08-13-2010, 01:16 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1