Challenge No. 336: Find the unique pair of numbers.
Solved using: Python in Excel.
Decrypt using 5×76 transposition cipher
Challenge No. 335: This is a 5 x 76 transposition cipher, where you start with the letter in the final position (‘W’) and then repeatedly step back through the whole ciphertext 5 positions at a time time, and then repeat that same process but starting from the letter one before the last position (‘T’) etc, revealing the first words of Geoffrey Chaucer’s ‘Canterbury Tales’.
Solved using: Python in Excel.
Custom Grouping! Part 19
Challenge No. 197: Group the rows sequentially from the top, ensuring that each group contains exactly one missing date.
Solved using:Excel (IF, LET, SCAN), Google Sheets, Power Query (Table.Group, Table.AddIndexColumn), Python, Python in Excel, and R.
Generate Soundex Codes
Challenge No. 128: Every Soundex code consists of a letter and three numbers, such as W-252.
Solved using: R.
List all Amicable numbers
Challenge No. 334: List the Amicable numbers.
Solved using: Python in Excel.
Extract string before any letter repeats
Challenge No. 333: Extract the string before any alphabet is repeated.
Solved using: R.
Column Splitting! Part 6
Challenge No. 196: Split the ID into two columns:
The first column should contain all letters.
Solved using:Excel (CONCAT, HSTACK, LAMBDA), Google Sheets, Power Query (List.Transform, Text.Select, Table.AddColumn), Python, Python in Excel, and R.
Get Zodiac from Date Range
Challenge No. 127: Find out the Zodiac signs for table T1 from Table T2.
Solved using: DAX.
Find Min and Max for all zones
Challenge No. 332: Find the Max and Min for all Zones.
Solved using: Python in Excel.
List numbers expressible as sum of two cubes
Challenge No. 331: List those numbers which can be expressed as the sum of cube of two numbers.
Solved using: Python in Excel.