— CAN YOU SOLVE THIS - EXCEL CHALLENGE 155 —
(Solutions in any language are also welcome for Excel Challenges)
Polybius cipher
Encrypt the text in column I as per grid in A2:G8.
You need to assign a number to a character as row 1 cell concatenated with column 1 cell of the grid (highlighted in Orange)
Hence, A=11, D=14, N = 32, V = 44, 0 = 53, 8 = 65…
If a character is not found in the grid, the same should not be encrypted.
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/dVuu39Y9
#excel, #excelchallenge, #powerquerychallenge, #daxchallenge, #m, #dax, #powerbi, #powerquery, #powerpivot, #sheets, #googlesheets, #data, #analytics, #businessintelligence, #finance, #office365, #python, #r
Excell BI’s LinkedIn Post