Removes a specified number of rows or columns from an array in Excel.
Challenge No. 102: In the historical sales table, identify and extract the dates where the sales value on that date is greater than the sales on the previous date.
Solved using:Excel (DROP, FILTER, IF), Google Sheets, Power Query (Table.AddColumn, Table.AddIndexColumn, Table.SelectColumns), Python, Python in Excel, R, and VBA.
Challenge No. 87: Find the Region and Year where and when the growth was the highest.
Solved using: DAX.
Challenge No. 86: Align the names under their respective cities.
Solved using: Power Query.
Challenge No. 97: In the question table, the population data for cities A, B, and C are provided for different years.
Solved using:Excel, Google Sheets, Power Query, Python, Python in Excel, and R.
Challenge No. 74: — This week will be FIFA World Cup week.
Solved using: SQL.
Challenge No. 70: — This week will be FIFA World Cup week.
Solved using: SQL.
Challenge No. 69: — This week will be FIFA World Cup week.
Solved using: SQL.
Challenge No. 94: In the question table, texts are provided for different groups.
Solved using:Excel (DROP, FILTER, HSTACK), Google Sheets, Power Query (List.Split, List.Transform, Table.ExpandTableColumn), Python, Python in Excel, and R.
Challenge No. 17: (Excel formulas also welcome)
Generate the output table.
Solved using: Power Query.
Challenge No. 11: Create blocks based on the sets of text number strings.
Solved using: Power Query.
