+ Reply to Thread
Results 1 to 4 of 4

How to devive same word when few characters in 2 words are different.

  1. #1
    Forum Contributor
    Join Date
    05-11-2013
    Location
    Mumbai
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    242

    How to devive same word when few characters in 2 words are different.

    Dear Friends.

    PFA

    In U9:U11, is there any way where we can derive output mentioned in W9:W11?.

    Formula in cells U9:U11 is give by the forum. But it fails in W9:W11.

    I need to reconcile huge database and manually doing the task is very time consuming.

    Please assist.
    Attached Files Attached Files
    Last edited by Pepe Le Mokko; 03-02-2020 at 03:33 AM. Reason: Moved to correct subforum

  2. #2
    Forum Contributor
    Join Date
    11-20-2007
    Location
    Felixstowe, England
    MS-Off Ver
    Excel 2013, 2019
    Posts
    176

    Re: How to devive same word when few characters in 2 words are different.

    You have given only 3 examples of simple results (same layout of xxx/nnn to get nnn). Describe what you expect the formulas to do? For example, for:

    BES/2894/18-19

    ?

  3. #3
    Forum Contributor
    Join Date
    05-11-2013
    Location
    Mumbai
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    242

    Re: How to devive same word when few characters in 2 words are different.

    Hello GlennUK,

    The output of BES/2894/18-19 should be BES/2894/18-19 since this bill no. is not found in range of U1001 onwards.

    In U9:U15, the formula should return the bill no. of U1001 onwards if the GST no. are same.

    Please assist.

  4. #4
    Forum Contributor
    Join Date
    11-20-2007
    Location
    Felixstowe, England
    MS-Off Ver
    Excel 2013, 2019
    Posts
    176

    Re: How to devive same word when few characters in 2 words are different.

    Try changing this part:
    MID($F9,6,9)
    to
    MID($F9,4,11)
    .... entered with Ctrl+Shift+Enter (I noticed that one of your formulas was not entered that way).

+ 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. How to devive same word when few characters in 2 words are different.
    By lalaarif1 in forum Excel Formulas & Functions
    Replies: 33
    Last Post: 02-29-2020, 03:17 PM
  2. [SOLVED] Compare two columns - words by word - display number of word match
    By nasrulla in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 10-24-2018, 06:18 AM
  3. How to derive same word when few characters in 2 words are different.
    By lalaarif1 in forum Microsoft Windows Help
    Replies: 1
    Last Post: 10-12-2018, 01:09 AM
  4. Count words and characters of hyperlinked word documents?
    By asterixo500 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-19-2015, 12:39 PM
  5. Sort on number of words (words with least characters first)
    By greenpine in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-23-2012, 10:00 PM
  6. [SOLVED] Replace Random Chinese Words (Not Characters) with Blank Spaces in MS Word
    By mlexcelhelpforum in forum Word Programming / VBA / Macros
    Replies: 8
    Last Post: 08-05-2012, 06:42 AM
  7. Sort on number of words (words with least characters first)
    By greek in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 01-23-2010, 04:10 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