Challenge No. 312: List all Sumproduct numbers from column A.
Solved using: Python 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.
Forecast Monthly Rounded Growth
Challenge No. 116: Prepare the forecast from Jul onwards.
Solved using: Python in Excel.
Find the next 3 Friday the 13th dates
Challenge No. 310: Find the next 3 Friday the 13th dates for dates given in column A.
Solved using: Python in Excel.
Convert ISBN10 to ISBN13 Numbers
Challenge No. 309: Convert ISBN10 to ISBN13 Numbers
1.
Solved using: Python in Excel.
Return Above Cell for Numbers
Challenge No. 115: If you encounter a number anywhere in a row, output the cell above that number along with the number.
Solved using: Python in Excel.
List Portmanteau words
Challenge No. 308: List Portmanteau words.
Solved using: Python in Excel.
Condition Formatting Headers
Challenge No. 52: Condition Format the Header Of Each Group
Dynamic array function allowed, but Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: R.