Challenge No. 468: This challenge was posed by Sunny Baggu
List the rows from problem table as per column H.
Solved using: Python in Excel.
BYCOL
Applies a function to each column in an array in Excel.
Unstack Groups for Summation
Challenge No. 193: Transpose the problem table into result table.
Solved using: Python in Excel.
Matrix Calculation! Part 2
Challenge No. 198: Create a formula that, for any ‘n x n’ matrix, calculates z1 to zn, where zi is the sum of all the values in the ith row and the ith column of the matrix.
Solved using:Excel (BYCOL, INDEX, LAMBDA), Google Sheets, Power Query (List.Transform, Table.FromRows, Table.ToColumns), Python, Python in Excel, and R.
Top Headers by Total
Challenge No. 220: First row is column headers and first column is row headers.
Solved using: Power Query (List.Transform).
Sort Cities by Populated
Challenge No. 169: Order the cities columns on the basis of number of cells populated in descending order.
Solved using: Python.
Reverse Cities Columns
Challenge No. 159: Reverse all columns from Cities1 to Cities5.
Solved using: Power Query (List.RemoveNull, List.Reverse, List.Transform).
Lookup and Concat Data Using a Criteria
Challenge No. 19: Lookup Subjects where at least 2 students scored 90 and above Dynamic array function allowed, but Extra marks for Legacy Array Functions or PowerQuery Solution.
Solved using: Power Query.
Remove Blank Columns!
Challenge No. 79: In the question table, some columns are entirely blank.
Solved using:Excel (BYCOL, FILTER), Power Query (List.Transform, Table.Column, Table.ColumnNames), Python, Python in Excel, R, and VBA.
Assignment Problem (Part 2)!
Challenge No. 50: In the continuation of the previous challenge, we reach the question table as the normalized table, in the rest of the algorithm the below step should be done.
Solved using:Excel (AND, BYCOL, BYROW), Power Query (List.Transform, Table.Column), Python, and R.
Assignment Problem (Part 1)!
Challenge No. 49: Assignment Problem is a well-known problem for assigning tasks to different people by the minimum cost and we want to solve it with The Hungarian method within two challenges.
Solved using:Excel (BYCOL, BYROW, HSTACK), Power Query (List.Skip, List.Transform, Table.Column), Python, and R.