Solution – Challenge 50 – Cryptography Challenge 3 – Generate Tabula Recta

Below is a possible solution to the Challenge 50 – Cryptography Challenge 3 – Generate Tabula Recta

Put following formula and drag down and right

=CHAR(MOD(ROWS($1:1)+COLUMNS($A:A)-2,26)+65)

A workbook containing the above solution can be downloaded from Solution – Challenge 50 – Cryptography Challenge 3 – Generate Tabula Recta