Challenge No. 158: List the top 3 players in decreasing order of duration.
Solved using: Python in Excel.
Power!
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.
Generate Unique Records Based on Rules
Challenge No. 45: Calculate Running Total for each dealer.
Solved using: SQL.
Workday Count Between Dates
Challenge No. 157: Find the number of workdays between two dates (From & To) for Weekends given in column E.
Solved using: Power Query (NETWORKDAYS.INTL).
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.
Data Validation
Challenge No. 40: Meeting Scheduled only on the following Workday (Mon, Wed, Fri) Write a dynamic formula to paste in Data Validation.
Solved using: Excel.
Polybius Cipher Encrypt
Challenge No. 155: Polybius cipher
Encrypt the text in column I as per grid in A2:G8.
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.
Convert Roman to Decimal
Challenge No. 154: Convert from Roman to Decimal.
Solved using: Python in Excel.