+ Reply to Thread
Results 1 to 1 of 1

Lookup similar value in the same column and if similarities found, return a single to all

  1. #1
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    2016
    Posts
    2,100

    Lookup similar value in the same column and if similarities found, return a single to all

    Hi,

    Is it possible to search for similarities in the same column and if there are similarities then add a single result for all found alike? there may be one or 2 different characters or truncated data( a small number of characters, maximum 4).

    Thanks,
    Paul
    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] Lookup part number in column and return heading if found
    By Gorbs in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-14-2015, 03:34 PM
  2. Replies: 4
    Last Post: 08-27-2015, 11:22 AM
  3. UDF to return one of each word found in a column to a single cell on another sheet
    By Doing my best in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-15-2014, 12:12 PM
  4. Formula to lookup two values in a row and return a value if both are found
    By onbeillp111 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-01-2014, 01:33 PM
  5. Replies: 4
    Last Post: 04-16-2010, 09:28 AM
  6. can lookup return err if no match found
    By Kim Greenlaw in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-11-2006, 01:45 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