Challenge No. 50: Create a Recruitment plan from the Projected Headcount.
Solved using: Python.
HSTACK
Stacks arrays horizontally into a single row in Excel.
Fill Alphabets in Pattern Columns
Challenge No. 110: Fill in the alphabets from Names column in Name1.
Solved using: Python in Excel.
Max Call Duration Pair
Challenge No. 298: Work our the pair of persons for whom the sum of call duration is the highest.
Solved using: Python in Excel.
Lookup Date When Target was Hit
Challenge No. 49: Lookup the date when the staff total sales hit or exceeded the target
Current target is 800, but needs to be dynamic
e.
Solved using: Python.
Generate Remaining Count Sentences
Challenge No. 295: Generate the given text from cell A2 onwards as per value given in cell A1.
Solved using: Python in Excel.
Table Transformation! Part 21
Challenge No. 177: Transform the question structure into the result structure.
Solved using:Excel (DROP, FILTER, HSTACK), Google Sheets, Power Query (Table.AddColumn, Table.ExpandTableColumn, Table.Group), Python, Python in Excel, and R.
Rank by Best of 3 Subjects
Challenge No. 106: Generate the result table from problem table.
Solved using: Power Query.
Custom Grouping! Part 16
Challenge No. 176: Group every five rows of the question table and then provide some of quantity for each group.
Solved using:Excel (GROUPBY, HSTACK, LAMBDA), Google Sheets, Power Query (Table.Group, List.Transform, Table.AddIndexColumn), Python, Python in Excel, and R.
Matches With Equal Goal Difference
Challenge No. 290: List the matches where goal difference is same.
Solved using: Python in Excel.
Custom Grouping! Part 15
Challenge No. 173: The Question table contains transactions recorded on different dates.
Solved using:Excel (HSTACK, LAMBDA, LET), Google Sheets, Power Query (Table.Group, Date.Month, Table.AddIndexColumn), Python, Python in Excel, and R.