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
Category: Challenges
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")
Challenge 51 – Another Word Challenge – Whether Given Words are Anagram or not
Given a word, an anagram is made by using all letters of the given word exactly once. For example, For example, my name "vijay" can be written as "jaivy", "yajvi" and so on….Some well known anagrams are Lead – Flea Admirer – Married Listen – Silent Mother in Law – Woman Hitler Eleven Plus Two…