Challenge No. 336: Find the unique pair of numbers.
Solved using: Python in Excel.
BYROW
Applies a function to each row in an array in Excel.
Column Combining! Part 1
Challenge No. 189: Given multiple columns, concatenate them based on a predefined pattern.
Solved using:Excel (BYROW, CONCAT, IF), Google Sheets, Power Query (List.ReplaceMatchingItems, List.Transform, List.Zip), Python, Python in Excel, and R.
Column Splitting! Part 4
Challenge No. 186: Split the ID into two columns:
The first column should contain all vowels (A, E, I, O, U).
Solved using:Excel (BYROW, CONCAT, HSTACK), Google Sheets, Power Query (Text.Combine, Text.Remove, Text.Select), Python, Python in Excel, and R.
Time Zone!
Challenge No. 166: In the provided table, the Date Time values correspond to different time zones (specified in the column GMT From).
Solved using:Excel (BYROW, HSTACK, LAMBDA), Google Sheets, Power Query (Text.End), Python, Python in Excel, and R.
List Year of Maximum Values
Challenge No. 93: List the Maximum Amount and the Years in which these maximum amounts occurred.
Solved using: Python in Excel.
Top Headers by Total
Challenge No. 220: First row is column headers and first column is row headers.
Solved using: Power Query (List.Transform).
Pay All Quarters Customers
Challenge No. 208: Find those customers who have made at least one payment in all quarters in its range.
Solved using: Power Query.
Identify The Pattern !
Challenge No. 135: Find the number of occurrences of the “+-+” pattern across the test IDs for each product.
Solved using:Excel (BYROW, CONCAT, DROP), Google Sheets, Power Query (List.Range, Text.Combine, Table.AddColumn), Python, Python in Excel, and R.
Year Plus Digits Equals Current
Challenge No. 192: Excel formulas permit date range from 1-Jan-1900 to 31-Dec-9999.
Solved using: Python in Excel.
Find Max Sum Pairs
Challenge No. 190: Find the unique pairs of numbers whose sum is the maximum.
Solved using: Python in Excel.