— CAN YOU SOLVE THIS - EXCEL CHALLENGE 160 —
(Solutions in any language are also welcome for Excel Challenges)
Generate first 26 prime numbers starting with 2 till 101 (101 is 26th prime number). Assign them to English alphabets sequentially.
Hence A=2, B=3…Y=97, Z=101.
Sum the numbers for English alphabets given in Words.
Example - Car = C(5) + A(2) + R(61) = 68
Post answers in Comment.
(Your formula need not be a single formula. You can write multiple formulas to arrive at a solution. Also your formula need not be different from others as long as you have worked out your formula independently)
Download Practice File - https://lnkd.in/d6vHWNu7
#excel, #excelchallenge, #powerquerychallenge, #daxchallenge, #m, #dax, #powerbi, #powerquery, #powerpivot, #sheets, #googlesheets, #data, #analytics, #businessintelligence, #finance, #office365, #python, #r
Excel BI’s LinkedIn Post