Challenge No. 355: List all valid IPv6 addresses.
Solved using: Python in Excel.
⭐️⭐️⭐️ Intermediate
Moderate difficulty level.
Map Groups to Company
Challenge No. 137: Generate result table on the basis of 2 problem tables.
Solved using: Python in Excel.
Detect Common Groups by ID
Challenge No. 136: Find the common groups on the basis of common IDs.
Solved using: R.
Daily Stock Closing Value
Challenge No. 134: Yesterday’s challenge was a tough one.
Solved using: Python in Excel.
List valid South African National IDs
Challenge No. 342: List the valid South African National IDs (person identification numbers).
Solved using: Python in Excel.
Transpose First/Last Names
Challenge No. 131: Transpose the problem table into Result table.
Solved using: R.
Column Combining! Part 2
Challenge No. 199: Given multiple columns, concatenate them based on the order presented on the pattern column using space as a delimiter.
Solved using:Excel (BYROW, CHOOSECOLS, DROP), Google Sheets, Power Query (List.Transform, Text.Combine, Text.Split), Python, Python in Excel, and R.
Matrix Calculation! Part 2
Challenge No. 198: Create a formula that, for any ‘n x n’ matrix, calculates z1 to zn, where zi is the sum of all the values in the ith row and the ith column of the matrix.
Solved using:Excel (BYCOL, INDEX, LAMBDA), Google Sheets, Power Query (List.Transform, Table.FromRows, Table.ToColumns), Python, Python in Excel, and R.
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.