If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > PC based Database Applications > Microsoft Excel > duplictae: identify numeric string within another numeric string

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 07-21-04, 11:52
990405 990405 is offline
Registered User
 
Join Date: Jul 2004
Posts: 11
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
Reply With Quote
  #2 (permalink)  
Old 07-22-04, 04:15
starsky51 starsky51 is offline
Registered User
 
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.
Reply With Quote
  #3 (permalink)  
Old 07-24-04, 13:16
Vic2004 Vic2004 is offline
Registered User
 
Join Date: Jul 2004
Location: Italy
Posts: 2
I Need To Find String Of A1 In String Of B1
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On