Challenge No. 379: List all the numbers where all succeeding numbers are larger than the number.
Solved using: Python.
ROWS
Returns the number of rows in an array or range in Excel.
Split on First Greater Sum
Challenge No. 378: Split the numbers into two parts where sum of first part is > sum of second part where it happens for the first time.
Solved using: R.
Perform Faro Shuffle Types
Challenge No. 369: Faro Shuffle – Divide the data in two equal parts (data will always be even, so two equal parts).
Solved using: DAX.
Stack Matrix Diagonals Horizontally
Challenge No. 358: Stack both the diagonals of n x n metrices horizontally.
Solved using: Python in Excel.
Transpose People Table
Challenge No. 138: Transpose the problem table into result table.
Solved using: R.
Reverse Words Between Indexes
Challenge No. 351: Reverse the words between two words whose both inclusive positions are given.
Solved using: Python in Excel.
Find Longest Consecutive Sequence
Challenge No. 347: List the largest group of consecutive numbers in each column.
Solved using: R.
Sum digits along diagonals of grid
Challenge No. 345: Find the sum of digits of both the diagonals for the grids given.
Solved using: R.
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.
List words longer than average word length
Challenge No. 330: Extract all the words which are greater than average length of the words in that sentence.
Solved using: R.