Complex challenges for experienced users.
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.
Challenge No. 190: Write a formula to convert texts into numbers.
Solved using:Excel, Google Sheets, Power Query, Python, R, and VBA.
Challenge No. 121: Transform the problem table into result table.
Solved using: Excel VBA.
Challenge No. 319: List all Powerful numbers.
Solved using: DAX.
Challenge No. 120: Fill in all empty values with average of contiguous non-empty values on immediate left.
Solved using: Power Query (List.Transform, Table.Column, Table.ColumnNames).
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.
Challenge No. 306: List all Semi Prime Numbers.
Solved using: Python in Excel.
Challenge No. 180: In the question table, parents and their children with different IDs are listed.
Solved using:Excel, Google Sheets, Power Query, Python in Excel, and R.
Challenge No. 109: For every entry, there has to be an exit which should come after entry.
Solved using: Excel VBA.
Challenge No. 106: Generate the result table from problem table.
Solved using: Power Query.
