Challenge No. 480: Decrypt the given Encrypted text.
Solved using: Python in Excel.
IF
Returns one value for TRUE and another for FALSE based on a condition in Excel.
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.
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.
Compile Role Based Totals
Challenge No. 206: Generate the result table from problem table.
Solved using: Python in Excel.
Detect Wavy Number Pattern
Challenge No. 474: Wavy numbers – List the numbers where digits alternately get smaller or larger (they should not be equal).
Solved using: Excel VBA.
Count Column Cross Matches
Challenge No. 204: For a column, find how many members of the column are contained in other columns.
Solved using: Python.
Average Between Blank Groups
Challenge No. 203: Prepare the groups which lie between two blank Amount1s and give the average of numbers appearing in those groups (groups shaded in light red).
Solved using: R.
Mark Overlapping Time Ranges
Challenge No. 467: If tasks’ From Time and To Time overlap with each other, mark them as Y.
Solved using: Python in Excel.