Posts by jindon

    Re: Extract similar words from selected sentences


    B2:


    =IFERROR(GetSimilar($A$2:$A$7,$I$2:$I$9,ROW(A1)),"")
    and copy down

    Re: Extract similar words from selected sentences


    UDF


    Use in cell like


    =GetSimiler(A1:A10,M1:M20)
    where 1 st argument(A1:A10) is the data range and 2 nd argument(M1:M20) is the Exclude word list.

    Re: Split text to columns and transfer to rows VBA


    Try

    Re: replacing cells with formulas with conditional check AND formula


    OK
    According to the formula in the last row of after.

    Re: Extract only unique words from selected sentences


    Re: Dynamisk Search List DropDown in a Userform, ComboBox


    I've just done for UserForm not combobox on the sheet.
    And just chage

    Code
    1. For Each e In dic
    2. If UCase$(e) Like UCase$(.Value) & "*" Then AL.Add e
    3. Next


    to

    Code
    1. For Each e In dic
    2. If UCase$(e) Like "*" & UCase$(.Value) & "*" Then AL.Add e
    3. Next

    Re: Dynamisk Search List DropDown in a Userform, ComboBox


    I've just done a similar thing