Applies a function to each element of one or more arrays in Excel.
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.
Challenge No. 336: Find the unique pair of numbers.
Solved using: Python in Excel.
Challenge No. 334: List the Amicable numbers.
Solved using: Python in Excel.
Challenge No. 128: Every Soundex code consists of a letter and three numbers, such as W-252.
Solved using: R.
Challenge No. 333: Extract the string before any alphabet is repeated.
Solved using: R.
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.
Challenge No. 331: List those numbers which can be expressed as the sum of cube of two numbers.
Solved using: Python in Excel.
Challenge No. 195: In the ID column, the text should follow the format XX/XX/XX/XX (with a ‘/’ after every two characters).
Solved using:Excel (IF, LAMBDA, LEN), Power Query (List.Transform, Text.Combine, Text.Split), Python, Python in Excel, and R.
Challenge No. 194: For each date, samples are evaluated based on quality and marked with a “+” sign if they are within range and a “-” sign if they are out of range.
Solved using:Excel (DROP, HSTACK, IF), Google Sheets, Power Query (List.Transform, Text.Remove, Text.Split), Python, Python in Excel, and R.
Challenge No. 328: — Looks like scheduling didn’t work today and challenge didn’t get posted—
Remove the last minimum number from given strings.
Solved using: Python in Excel.
