Challenge No. 658: Word Square – A word square is a n x n matrix where row (i) = column (i).
Solved using: Python.
TRANSPOSE
Converts rows to columns and vice versa in Excel.
Find Maximum N-Digit Grid Number
Challenge No. 611: Find the N digit maximum number in given 6×6 grid either rows (left to right) or columns (top to down).
Solved using: Python.
Count Alphabetically Sorted Words
Challenge No. 601: Find the count of words in columns A through C if the words have sorted alphabets.
Solved using: Python in Excel.
Odd Numbers All Directions
Challenge No. 550: Last week, we had this challenge.
Solved using: Python in Excel.
Calculate Monthly Payments
Challenge No. 217: Transpose the table as shown by showing the amount paid each month.
Solved using: Python in Excel.
Show Transposed Amount Values
Challenge No. 216: Transpose the table as shown.
Solved using: Excel VBA.
Summarize Yearly Sales
Challenge No. 207: Generate the result table from problem table.
Solved using: Python in Excel.
Mark Overlapping Time Ranges
Challenge No. 467: If tasks’ From Time and To Time overlap with each other, mark them as Y.
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).