Challenge No. 249: Multiply first digit with second digit, then result of this should be multiplied with 3rd digit and so on.
Solved using: Power Query.
IF
Returns one value for TRUE and another for FALSE based on a condition in Excel.
Custom Grouping! Part 10
Challenge No. 153: The table includes two columns, From and To, where each row represents a range of dates.
Solved using:Excel (DROP, HSTACK, IF), Google Sheets, Power Query (Table.Group), Python, Python in Excel, and R.
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.
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.
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.
Sorted Vowel Substitution
Challenge No. 239: Replace the vowels with vowels in sorted order.
Solved using: Excel VBA.
Table Transformation! Part 16
Challenge No. 147: Transform the question structure into the result structure.
Solved using:Excel (FILTER, HSTACK, IF), Google Sheets, Power Query (List.Skip, List.Split, Table.AddColumn), Python, Python in Excel, R, and VBA.