Challenge No. 364: List the numbers where absolute difference between two succeeding digits is 1, 2, 3, 4.
Solved using: Python.
DROP
Removes a specified number of rows or columns from an array in Excel.
Exclude Weekend Vacation Dates
Challenge No. 139: Prepare the Result table.
Solved using: DAX.
Find Longest Consecutive Sequence
Challenge No. 347: List the largest group of consecutive numbers in each column.
Solved using: R.
List all Katadrome numbers
Challenge No. 344: List all Katadrome numbers.
Solved using: Python in Excel.
Column Combining! Part 2
Challenge No. 199: Given multiple columns, concatenate them based on the order presented on the pattern column using space as a delimiter.
Solved using:Excel (BYROW, CHOOSECOLS, DROP), Google Sheets, Power Query (List.Transform, Text.Combine, Text.Split), Python, Python in Excel, and R.
Pattern Length!
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.
Table Transformation! Part 24
Challenge No. 192: Any row with a negative quantity should reduce the corresponding value in the previous rows for the related product.
Solved using:Excel (DROP, FILTER, LAMBDA), Google Sheets, Power Query (Table.Group, Table.SelectRows, Table.Sort), Python, Python in Excel, and R.
Custom Grouping! Part 17
Challenge No. 187: Group the rows until encountering a missing date.
Solved using:Excel (DROP, GROUPBY, IF), Google Sheets, Power Query (Table.Group, Table.AddColumn, Table.AddIndexColumn), Python, Python in Excel, and R.
Generate the result table with Tn = T(n-2) & Tn
Challenge No. 313: Generate the result table.
Solved using: Python in Excel.
Extracting Whole Route
Challenge No. 53: Generate a whole route for the airlines
e.
Solved using: R.