1. Make a backup of your workbook. 2. Open your workbook and ALT+F11 3. Locate your Workbook name in Project Explorer Window 4. Right click on your workbook name > Insert > Module
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.
Tips & Tricks 148 – Get Battery Charging Status
1. Make a backup of your workbook. 2. Open your workbook and ALT+F11 3. Locate your Workbook name in Project Explorer Window 4. Right click on your workbook name > Insert > Module
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…
Downloads 08 – Template 08 – Thermometer Chart Template
< The template can be downloaded from Template 08 – Thermometer Chart > Thermometer Chart is used to show the progress towards a goal. It is generally used to reflect on the percentage achievement. The template here gives many different type of Thermometer charts. You can create many more and / or format existing ones…
Tips & Tricks 147 – Find the Location of Excel.Exe
Generally Excel.Exe will be located in C:\Program Files (x86)\Microsoft Office\Office15 in case of Excel 2013 / Windows 7. During installation, if another path is chosen, Excel.Exe's location changes. Default Path is also dependent upon Office and Windows combinations. Sometimes, it may not be locatable at all. To find the location of Excel.Exe – 1. Start…
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…