Challenge No. 337: Find the Min, Max and Count of numbers having number of digits in column A whose product of digits is equal to column B.
Solved using: R.
LET
Assigns names to values or calculations to simplify formulas in Excel.
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.
Find unique number pairs
Challenge No. 336: Find the unique pair of numbers.
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.
List all Amicable numbers
Challenge No. 334: List the Amicable numbers.
Solved using: Python in Excel.
Generate Soundex Codes
Challenge No. 128: Every Soundex code consists of a letter and three numbers, such as W-252.
Solved using: R.
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.
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.