Challenge No. 121: Create the given table for the continuous values of power and bases.
Solved using:Excel (LAMBDA, MAKEARRAY, ROW), Office Script, Power Query (List.Transform), and Python in Excel.
List.Transform
Applies a function to each element in a list in Power Query.
Find Pythagorean Dates
Challenge No. 156: Pythagorean dates are those dates where DD^2 + MM^2 = YY^2
For example: 16-Dec-2020 where 16^2 + 12 ^2 = 20^2
List all Pythagorean dates (in YYYYMMDD format) from current century.
Solved using: Python in Excel.
Payments Duration!
Challenge No. 120: In challenge 60, we attempted to calculate the source of payment for each receipt.
Solved using:Excel, Google Sheets, Power Query (List.Transform), Python in Excel, and R.
Find Customer Stats With Conditions
Challenge No. 44: Generate result table as shown.
Solved using: Python in Excel.
Remove Words by Index
Challenge No. 152: Remove the Words from column A as per index in column B.
Solved using: Excel VBA.
Generate result table from the
Challenge No. 40: Generate the result table from the problem table as shown.
Solved using: Python.
Sum Negative Numbers Only
Challenge No. 135: Extract the negative numbers and sum them from the given strings.
Solved using: Python in Excel.
Duplicate Values! Part 2
Challenge No. 113: Consider the IDs in the question table.
Solved using:Excel (DROP, IF, LAMBDA), Google Sheets, Power Query (List.Transform, Table.AddColumn, Table.AddIndexColumn), Python, Python in Excel, and R.
Capitalize First and Last
Challenge No. 130: Convert the first and last letters of each word to upper case.
Solved using: Power Query (List.Transform).
Calculate Digital Root
Challenge No. 121: Calculate Digital root of the given numbers.
Solved using: Python in Excel.