Challenge No. 190: Write a formula to convert texts into numbers.
Solved using:Excel, Google Sheets, Power Query, Python, R, and VBA.
Transform Source to Result Table
Challenge No. 121: Transform the problem table into result table.
Solved using: Excel VBA.
Find largest sum of contiguous cells
Challenge No. 320: Work out the largest sum for contiguous cells given in the range A2:A10.
Solved using: DAX.
Calculating Cumulative Debt
Challenge No. 55: Calculate Cumulative Debt
Previous day debt is to be cleared with current day budget There’s NO Excess Budget carry-over
e.
Solved using: Python.
List all Powerful numbers
Challenge No. 319: List all Powerful numbers.
Solved using: DAX.
Column Combining! Part 1
Challenge No. 189: Given multiple columns, concatenate them based on a predefined pattern.
Solved using:Excel (BYROW, CONCAT, IF), Google Sheets, Power Query (List.ReplaceMatchingItems, List.Transform, List.Zip), Python, Python in Excel, and R.
Average Fill for Blank Months
Challenge No. 120: Fill in all empty values with average of contiguous non-empty values on immediate left.
Solved using: Power Query (List.Transform, Table.Column, Table.ColumnNames).
Find the Sum of the Series
Challenge No. 318: Find the Sum of the Series – 1*2*3 + 2*3*4 + 3*4*5+.
Solved using: DAX.
Swap first and last letters unless vowels
Challenge No. 317: Swap the first and last letter of each words in given names.
Solved using: DAX.
Matrix Calculation! Part 1
Challenge No. 188: Create a formula that, for any given value of ‘n’, generates an ‘n x n’ identity matrix where all values are 0, except for the diagonal (primary) values, which should be 1.
Solved using:Excel (IF, LAMBDA, LET), Google Sheets, Power Query (List.Transform), Python, and Python in Excel.