riyaz
Excel 4 functions are not Macro, to work you have to enable Macro and save with XLSM extension, I repeat is not Macro
Hope this helps
Decio
riyaz
Excel 4 functions are not Macro, to work you have to enable Macro and save with XLSM extension, I repeat is not Macro
Hope this helps
Decio
Sorry, Type CTRL + SHIFT + ENTER formula array
Decio
Use this formula
=INT(NPV(-0.9,IFERROR(MID(A1,1+LEN(A1)-ROW(INDIRECT("1:"&LEN(A1))),1)/10,"")))
Decio
I apologize, Ingles is not my native language, I am from Brazil, Portuguese language, I use Google Translator, it can translate wrong.
Formula ""*"&MID($E3,ROW(INDIRECT("$1:$"&LEN($E3))),1)&"*"" transforms into {"* 4 *", "* 5 *", "* 9 *"}
Transforms Word into each letter
Formula "SEARCH("*"&MID($E3,ROW(INDIRECT("$1:$"&LEN($E3))),1)&"*",D3,1)" transforms in {1; 1; 1}
Search if you have the same in the text, each letter, finding mark number 1
Formula "IFERROR(SEARCH("*"&MID($K5,ROW(INDIRECT("$1:$"&LEN($K5))),1)&"*",J5,1),0)" transform into {1; #VALOR!; 1}
Transforms error in value zero (0)
Formula "SUMPRODUCT(IFERROR(SEARCH("*"&MID($K5,ROW(INDIRECT("$1:$"&LEN($K5))),1)&"*",J5,1),0))" , the result of the search results of sum is 3
compares with the amount of character that has the word
If equal then correct has all the characters
I hope I have helped, click on Like so is a way of thanking
Decio
Maxim
Check if this is the way you want it
Decio
Re: Auto fill cells with Letter Value
This is how you want it
=SUMPRODUCT(I$1:I$26*ISNUMBER(SEARCH(K$1:K$26,M1:S1)))
Decio