Challenge No. 312: List all Sumproduct numbers from column A.
Solved using: Python in Excel.
MAP
Applies a function to each element of one or more arrays in Excel.
Extracting Whole Route
Challenge No. 53: Generate a whole route for the airlines
e.
Solved using: R.
Sort the digits of given numbers in descending order
Challenge No. 311: Sort the digits of given numbers in column A in descending order.
Solved using: Python in Excel.
Replace Consecutive X!
Challenge No. 185: In the ID column, Replace all instances of “X” if it appears consecutively more than once with just an “X”.
Solved using:Excel (DROP, HSTACK, IF), Google Sheets, Power Query (Text.Combine, Table.Group, Table.TransformColumns), Python, Python in Excel, and R.
Convert ISBN10 to ISBN13 Numbers
Challenge No. 309: Convert ISBN10 to ISBN13 Numbers
1.
Solved using: Python in Excel.
List Portmanteau words
Challenge No. 308: List Portmanteau words.
Solved using: Python in Excel.
List all Palindromic phrases
Challenge No. 307: List all Palindromic phrases.
Solved using: Python in Excel.
Match Dates!
Challenge No. 183: In the question table, the dates are provided in various formats.
Solved using:Excel (IFERROR, INDEX, LAMBDA), Google Sheets, Power Query (Text.Split, Table.Distinct, Table.TransformColumns), Python, Python in Excel, and R.
Categorize Time Intervals Status
Challenge No. 114: Count Early, On Time, Late and Out of Limit for T2 against T1.
Solved using: DAX.
Rank Teams by Total Points
Challenge No. 304: Wins (W), Drawn (D) and Lost (L) have weightages of 1, 0 & -1.
Solved using: Python in Excel.