Removes a specified number of rows or columns from an array in Excel.
Challenge No. 154: Add an index column to the question table, which has the same index value for every consecutive date.
Solved using:Excel (DROP, IF, LAMBDA), Google Sheets, Power Query (Table.AddColumn, Table.AddIndexColumn, Table.Column), Python, Python in Excel, and R.
Challenge No. 153: The table includes two columns, From and To, where each row represents a range of dates.
Solved using:Excel (DROP, HSTACK, IF), Google Sheets, Power Query (Table.Group), Python, Python in Excel, and R.
Challenge No. 245: List all Diamond strings from column A.
Solved using: R.
Challenge No. 150: Theeight-queenss puzzle is the problem of placing eight chess queens on an 8×8 chessboard so that no two queens threaten each other; thus, a solution requires that no two queens share the same row, column, or diagonal.
Solved using:Excel (DROP, IF, LAMBDA), Google Sheets, Power Query (List.Combine, List.Transform), and Python in Excel.
Challenge No. 148: For each customer, filter their first, last, and middle transactions from the provided “transactions” table.
Solved using:Excel (CHOOSEROWS, DROP, FILTER), Google Sheets, Power Query (Table.Combine, Table.Group), Python, Python in Excel, and R.
Challenge No. 75: Groups are separated by blank rows in Problem table.
Solved using: Python in Excel.
Challenge No. 73: Multiply Alpha, Beta, Gamma columns with Factor column.
Solved using: Python in Excel.
Challenge No. 144: From the provided “transactions” table, filter the first transaction for each.
Solved using:Excel (DROP, FILTER, LAMBDA), Google Sheets, Power Query (Date.Month, Table.AddColumn, Table.Group), Python, Python in Excel, and R.
Challenge No. 223: Sort the rows in columns A through H as per Sort key.
Solved using: Power Query.
Challenge No. 142: The Question table contains information about the fingerprinting times for various personnel when entering the company.
Solved using:Excel (DROP, HSTACK, IF), Google Sheets, Power Query (Table.AddColumn, Table.Group, Table.Pivot), Python, Python in Excel, and R.
