Challenge No. 499: Lynch Bell Numbers – Generate the first 500 Lynch Bell Numbers starting with 2 digits.
Solved using: Excel VBA.
LET
Assigns names to values or calculations to simplify formulas in Excel.
Mark Completed Tasks Only
Challenge No. 218: Transpose the table as shown.
Solved using: Python in Excel.
List WC Champion Years
Challenge No. 498: Align the soccer WC champions year wise (year in descending order).
Solved using: Python in Excel.
Grouping
Challenge No. 69: Create Qty Group and Sum the Amount
Dynamic array function allowed, but Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: R.
Calculate Monthly Payments
Challenge No. 217: Transpose the table as shown by showing the amount paid each month.
Solved using: Python in Excel.
Fill Sequence and Compute Sum
Challenge No. 497: For given range A2:A100, populate 1, 2, 3.
Solved using: Python in Excel.
Show Transposed Amount Values
Challenge No. 216: Transpose the table as shown.
Solved using: Excel VBA.
List First 10 Tech Numbers
Challenge No. 494: Generate the first 10 Tech Numbers.
Solved using: R.
Index Range Closest to 100
Challenge No. 493: List the Start and End Indexes where sum of numbers <=100 with minimum gap between sum of numbers and 100. Solved using: R.
Outstanding Loan Day Count
Challenge No. 215: Assuming today’s date is 7-Sep-24, pivot the table as shown for Outstanding loans.
Solved using: Python in Excel.