Forum Discussion
Solved
Translate letters in a string to a specified numerical value and summing them up
Hi all, could you please help me with the following issue? 1) I have a table with numerical values specified for each letter, e.g., A is 1, B is 2, C is 3, J is 1 again, K is 2 and so on. 2...
I opened this file on another computer and it show me another Cyrillic code page. Thus shifted in formula on UNICODE, perhaps that will be more reliable.
Formula is
=SUMPRODUCT( MOD(UNICODE(MID(B29,ROW(INDIRECT("1:"&LEN(B29))),1))-1040+ (UNICODE(MID(B29,ROW(INDIRECT("1:"&LEN(B29))),1))>1045),9)+ 1+3*(UNICODE(MID(B29,ROW(INDIRECT("1:"&LEN(B29))),1))=1025) )
kamapaka The attached file contains two possible solutions. Depending on your Excel version one of them may not work.
thank you very much!
the solution with "sequence" did not work - my version of Excel does not support that function.
the other solution worked.