Challenge No. 211: Append the groups one below the other and sort on Income descending, Name ascending within each group.
Solved using: R.
DROP
Removes a specified number of rows or columns from an array in Excel.
Leave Group From To
Challenge No. 210: Populate the From and To Date based on type of leaves for a person.
Solved using: Python.
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.
Summarize Yearly Sales
Challenge No. 207: 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.
Compile Role Based Totals
Challenge No. 206: Generate the result table from problem table.
Solved using: Python in Excel.
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.
List Bouncy Numbers
Challenge No. 466: A Bouncy number is any non-negative integer that is neither increasing nor decreasing.
Solved using: Excel VBA.
Task Assignment Load Balancing
Challenge No. 465: There are 4 persons who can be a candidate to do a task.
Solved using: Python in Excel.