Do Not Sell My Personal Information Jump to content

Excel Formula Help Please


Recommended Posts

need a formula to do the following.

Have the letters A to P.

Have 12 letters from the above 16.

Need the formula to check the 12 and return the missing letters.

i have lots of these to check, so would like a formula to do it in one hit..


Link to comment
Share on other sites

You'll have to add a macro.

Open Excel then :

Tools / Macro / Visual Basic Editor

Insert / Module

Click on the (new) Module1

Paste in the following :

Public Function MissingLetters(ByVal strSource As String) As String

    Dim intIdx As Integer

    Dim strResult As String




    strSource = UCase(strSource)

    For intIdx = 1 To Len(KEYSTR)

        If InStr(strSource, Mid(KEYSTR, intIdx, 1)) < 1 Then

            strResult = strResult & Mid(KEYSTR, intIdx, 1)

        End If

    Next intIdx


    MissingLetters = strResult


End Function

Save and close the VB editor

You should now have a new user defined function called 'MissingLetters()'

Use it like any other function.

Hope this does what you want.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...