In India, 2nd and 4th Saturdays are very important days as on these days, the banks remain closed. Hence, banks in India are closed on all Sundays and 2nd and 4th Saturdays apart from their holiday calendar. To calculate Networkdays for banking industry in India needs that the list of 2nd and 4th Saturdays needs…
Category: Challenges
Challenge 59 – Clean the Problem Workbook Data
Download the the workbook from the below link. The Challenge before you is to write a formula to clean the data. If you perform any mathematical operation on the data, it will return #VALUE error. You need to clean the data through a formula. Challenge 59 – Problem Workbook The solution to the above problem…
Solution – Challenge 58 – Make a Vedic Square
Below is a possible solution to Challenge 58 – Make a Vedic Square Put the following formula in C3 and drag right and down =MOD(C$2*$B3-1,9)+1 The Excel sheet having this solution can be downloaded from Solution – Challenge 58 – Make a Vedic Square
Solution – Challenge 57 – Another Word Challenge – Palindrome or Not
Below is a possible solution to the Challenge 57 – Another Word Challenge – Palindrome or Not Use the below formula –
Solution – Challenge 56 – Cryptography Challenge 5 – Fully Functional Caesar’s Shift Cipher Decrypter
Below is a possible solution to Challenge 56 – Cryptography Challenge 5 – Fully Functional Caesar’s Shift Cipher Decrypter
Challenge 58 – Make a Vedic Square
Vedic square is below. In this, first row and first column are numbers 0 and 9. Other numbers are populated as per logic which you will need to identify. More about Vedic Square at https://en.wikipedia.org/wiki/Vedic_square
Solution – Challenge 55 – Make an Alphabetic Triangle
Below is a possible solution to Challenge 55 – Make an Alphabetic Triangle Put following formula AB4 somewhere and drag to the right.
Challenge 57 – Another Word Challenge – Palindrome or Not
We earlier had challenges related to Pangram, Isogram and Anagram. This time, it is about Palindrome. A Palindrome is a word / sentence that reads the same from backward also as it reads from forward. Some of the famous Palindromes are
Solution – Challenge 54 – Make a Sequence like A_B__C___D____E_____F……
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…