Challenge No. 483: Generate a 20×20 matrix as given through a formula.
Solved using: Python in Excel.
LET
Assigns names to values or calculations to simplify formulas in Excel.
Score Matrix for Team Matches
Challenge No. 482: Prepare the given matrix from problem table.
Solved using: Python in Excel.
Decrypt Caesar Cipher Variation
Challenge No. 480: Decrypt the given Encrypted text.
Solved using: Python in Excel.
Add Task Duration to Start
Challenge No. 209: Populate the End dates against all owners in a pivot format as shown.
Solved using: Python.
Insert Group Name
Challenge No. 66: Group the staff and insert the group name after the last count.
Solved using: Python.
Generate Recaman’s Sequence
Challenge No. 479: Calculate first 10000 entries of Recaman’s sequence –
a(0) = 0,
for n > 0, a(n) = a(n-1) – n if nonnegative and not already in the sequence,
otherwise a(n) = a(n-1) + n.
Solved using: Python in Excel.
Merge Tables by Org and Year
Challenge No. 478: Merger the tables into a single table.
Solved using: Python.
Triangular Record Grouping
Challenge No. 477: Align the data as shown which is 1 record, then 2 records, then 3 records and so on.
Solved using: Python in Excel.
Distribute Sales Equally
Challenge No. 476: Divide the Sales from Table1 into Table2 equally over Stores.
Solved using: Python.
Summarize Yearly Sales
Challenge No. 207: Generate the result table from problem table.
Solved using: Python in Excel.