Below is a possible solution to the challenge Challenge 54 – Make a Sequence like A B C D E F…… Put below formula as array formula in a cell and drag down =IFERROR(CHAR(MATCH(ROWS($1:1),(ROW($1:$26)*(ROW($1:$26)+1))/2,0)+64),"")
Challenge 56 – Cryptography Challenge 5 – Fully Functional Caesar’s Shift Cipher Decrypter
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…
Downloads 09 – Template 09 – Stakeholder Register
< The template can be downloaded from Template 09 – Stakeholder Register > This is a fairly detailed template which you can shorten if you wish. But the recommendation is to use the full template to get complete benefit from Stakeholder Analysis.
Article 43 – Optimize, Troubleshoot and Improve Performance in Excel (non VBA)
Below points will help you in following to optimize your excel sheet Reduce time taken to calculate / recalculate Reduce time taken to open / close workbook Reduce file size Below points may not be valid in many circumstances so you will have to see the suitability of a recommendation but most of the time,…
Tips & Tricks 149 – Battery Charge Remaining
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…