Challenge No. 243: Polybius Cipher Decrypter –
Decrypt the text in column I as per grid in A2:G8.
Solved using: Excel VBA.
SEQUENCE
Generates a sequence of numbers in an array in Excel.
Eight Queens Puzzle!
Challenge No. 150: Theeight-queenss puzzle is the problem of placing eight chess queens on an 8×8 chessboard so that no two queens threaten each other; thus, a solution requires that no two queens share the same row, column, or diagonal.
Solved using:Excel (DROP, IF, LAMBDA), Google Sheets, Power Query (List.Combine, List.Transform), and Python in Excel.
Prime Difference Category
Challenge No. 242: If Number1 and Number2 are primes and if difference between them is:
2 – Twin Prime
4 – Cousin Prime
6 – Sixy Prime
Categorize the Numbers given in column A and B.
Solved using: Power Query (List.Transform).
Alternate Letter Casing
Challenge No. 241: Convert the English letters into small and capital alternately.
Solved using: Excel VBA.
Rotate Rows and Columns
Challenge No. 240: Now rotation has to be done for both columns and rows.
Solved using: Power Query.
Sum Values by Letter Codes
Challenge No. 77: Generate the result table from problem table.
Solved using: Python in Excel.
Sorted Vowel Substitution
Challenge No. 239: Replace the vowels with vowels in sorted order.
Solved using: Excel VBA.
Count Stepping Numbers
Challenge No. 238: Stepping Number is that number where adjacent digits have the difference of 1 or -1.
Solved using: Python in Excel.
Incremental Caesar Cipher
Challenge No. 236: We had 3 challenges on Caesar’s Cipher (if you are unaware about Caesar’s Cipher, I will encourage you to visit previous challenge to get an idea)
This is a variation of Caesar’s Cipher.
Solved using: Power Query (List.Transform).
Sum Groups Separated by Blanks
Challenge No. 75: Groups are separated by blank rows in Problem table.
Solved using: Python in Excel.