We made ourselves familiarized with Caesar's Shift in Challenge 39 – Cryptography Challenge 1 – Caesar's Shift Cipher and made its decrypter in Challenge 53 – Cryptography Challenge 4 – Caesar's Shift Cipher Decrypter. We also made a fully functional encrypter in Challenge 40 – Cryptography Challenge 2 – Fully Functional Caesar’s Shift Cipher based on…
Category: Challenges
Solution – Challenge 53 – Cryptography Challenge 4 – Caesar's Shift Cipher Decrypter
Below is a possible solution to the Challenge 53 – Cryptography Challenge 4 – Caesar's Shift Cipher Decrypter. Put following formula and drag down =IFERROR(CHAR(IF(CODE(LOWER(G2))-$B$3<97,CODE(G2)-$B$3+26,CODE(G2)-$B$3)),"") The Excel file containing the solution can be downloaded from Solution – Challenge 53 – Decryption – Caesar's Shift Cipher
Challenge 55 – Make an Alphabetic Triangle
This time challenge before you is to write a formula which can be dragged down, left and right to make the below triangle.
Solution – Challenge 52 – Generate the Sequence 1,2,2,3,3,3,4,4,4,4,5,5,5,5,5…
Below is a possible solution to the challenge Challenge 52 – Generate the Sequence 1,2,2,3,3,3,4,4,4,4,5,5,5,5,5… Put following formula and drag down =FLOOR((1+((1+8*ROWS($1:1)-1)^0.5))/2,1)
Challenge 54 – Make a Sequence like A_B__C___D____E_____F……
This time challenge before you is to write a formula which can be dragged down and leaves so many blank cells – 1 before that alphabet's position in English Language. Hence, the sequence will start with A, will leave 1 blank cell, then B, then 2 blank cells, then C, then 3 blank cells, then…
Solution – Challenge 51 – Another Word Challenge – Whether Given Words are Anagram or not
Below is a possible solution to the Challenge 51 – Another Word Challenge – Whether Given Words are Anagram or not Use following formula – =IF(AND(LEN(A1)=LEN(B1),SUMPRODUCT(–(LEN(A1)-LEN(SUBSTITUTE(UPPER(A1), UPPER(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)),""))=LEN(B1)-LEN(SUBSTITUTE( UPPER(B1),UPPER(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)),""))))=LEN(A1)),"Anagram","Not Anagram")
Challenge 53 – Cryptography Challenge 4 – Caesar's Shift Cipher Decrypter
We published a cryptography challenge Challenge 39 – Cryptography Challenge 1 – Caesar's Shift Cipher. The purpose of the challenge was to create an Excel based Encrypter. This time, we need to create the de-crypter for the same. The Excel file related to this challenge can be downloaded from Challenge 53 – Decryption – Caesar's…
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
Challenge 52 – Generate the Sequence 1,2,2,3,3,3,4,4,4,4,5,5,5,5,5…
This time challenge before you is to write a formula which generates a sequence where every digit appears that many times as that digit. Hence, 3 will repeat 3 times, 8 will repeat 8 times and so on..Hence, the exact sequence would be 1,2,2,3,3,3,4,4,4,4,5,5,5,5,5,6,6,6,6,6,6,7,7,7,7,7,7,7….. The solution to above challenge will be published after a month…
Solution – Challenge 49 – Whether a Word is Isogram or Not
Below is a possible solution to the challenge – Challenge 49 – Whether a Word is Isogram or Not Use following formula – =IF(SUMPRODUCT(–(LEN(A1)-LEN(SUBSTITUTE(UPPER(A1),CHAR(ROW($65:$90)),""))>1)) =1,"Not Isogram","Isogram")