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
scratchmaster
Sorry for using the translator, but now I understood what you explained, but colleague NBVC, made a correct formula, I was far from finding a solution.
Thank you
Decio
NBVC
Fantastic, good logic
Decio
Question
If Draw 4 3325 my correct formula in 3952, find # 3 # 3 # 2 # 5 has # 3 repeated
Because this is wrong Draw 4 1213 My wrong formula, find # 1 # 2 # 1 # 3 has # 1 repeated
Explain
Decio
I managed to understand the translation but I am not finding a solution to this problem, I did not give up I am doing tests, but if any member of this forum find the solution please post.
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
Check if this is what you want
Decio
[ATTACH]n1201110[/ATTACH]
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