Challenge No. 82: Generate the result table from problem table where Assignee and Priority are one below the other.
Solved using: Python in Excel.
Month and Quarter by Index
Challenge No. 248: Print the name of month & quarter as per position of 1.
Solved using: Power Query.
Case-Sensitive Reverse Cipher
Challenge No. 247: This problem is an extension of first challenge.
Solved using: Excel VBA.
Top 3 Students Per Subject
Challenge No. 81: Generate Top 3 students in all subjects.
Solved using: Power Query.
Sort Words by End Digit
Challenge No. 246: All words have a one digit number as its last character.
Solved using: Power Query.
Identify Diamond Strings
Challenge No. 245: List all Diamond strings from column A.
Solved using: R.
Cumulative Row-Wise Totaling
Challenge No. 79: Perform cumulative sum across the rows.
Solved using: Power Query.
Find Super Palindromes
Challenge No. 244: List all Super-palindromes from column A.
Solved using: Python in Excel.
Decrypt Polybius Cipher Grid
Challenge No. 243: Polybius Cipher Decrypter –
Decrypt the text in column I as per grid in A2:G8.
Solved using: Excel VBA.
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.