+ Reply to Thread
Results 1 to 6 of 6

Check digits between column

Hybrid View

  1. #1
    Registered User
    Join Date
    06-17-2008
    Posts
    9
    Trebor76,rylo : you are excellent! That it work! thanks for all the help!

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,834
    UDF
    Use in cell like
    =If(iamrony(A1,B1)=0,"",iamrony(A1,B1))
    Function iamrony(txt1 As String, txt2 As String) As Long
    Dim i As Integer, flg As Boolean
    If txt1 = txt2 Then Exit Function
    i = 1
    Do While i <= Application.Max(Len(txt1), Len(txt2))
        If (i > Application.Min(Len(txt1), Len(txt2))) + _
           (Mid$(txt1,i) <> Mid$(txt2,1)) Then
            flg = True
            Exit Do
        End If
        i = i + 1
    Loop
    If flg Then iamrony = i
    End Function

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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