Challenge No. 213: Merge the 2 tables and pivot them on Item with Total Row and Total Column.
Solved using: Python in Excel.
By Topic
Challenges categorized by topic.
Salesperson Commission Breakdown
Challenge No. 212: Find the total commission of each sales person and sort it descending on total amount.
Solved using: Python.
Carriage Return
Challenge No. 67: Split the data into separate rows
Combined data is separated by a carriage return
Not all rows have carriage returns
Dynamic array function allowed but Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: Python.
Group by Income Then Sort
Challenge No. 211: Append the groups one below the other and sort on Income descending, Name ascending within each group.
Solved using: R.
Leave Group From To
Challenge No. 210: Populate the From and To Date based on type of leaves for a person.
Solved using: Python.
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.
Merge Tables by Org and Year
Challenge No. 478: Merger the tables into a single table.
Solved using: Python.
Calculate Three Year Average
Challenge No. 208: Find the defects for each month group for which 3 years moving averages (MV) are given.
Solved using: Python in Excel.