Do Not Sell My Personal Information Jump to content


Excel Formula Help Please


Fargo
 Share

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..

help

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

   

    Const KEYSTR = "ABCDEFGHIJKLMNOP"

   

    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.

Guest
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.

 Share



×
×
  • Create New...




Forums


News


Membership