Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2004
    Posts
    11

    Unanswered: duplictae: identify numeric string within another numeric string

    Is there a method to identify a numeric string within another numeric string and then express "duplicate"

    As exmple data:

    097102105111114100105112101108108101
    could appear in another string

    09710210511111410010511210110810810110010511410110 3105110097116111115111110105097

    this would give me an indication that they could possibly be duplicates

    all values are contained within same row, if duplicate appears then print "duplicate" in next column

  2. #2
    Join Date
    Feb 2002
    Posts
    8
    Assuming A1 contains the first string and B1 contains the second string you could use:
    =IF(FIND(A1,B1),"DUPLICATE","")

    Dave.

  3. #3
    Join Date
    Jul 2004
    Location
    Italy
    Posts
    2
    I Need To Find String Of A1 In String Of B1

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •