Challenge No. 66: Group the staff and insert the group name after the last count.
Solved using: Python.
VSTACK
Stacks arrays vertically into a single column in Excel.
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.
Merge Tables by Org and Year
Challenge No. 478: Merger the tables into a single table.
Solved using: Python.
Summarize Yearly Sales
Challenge No. 207: Generate the result table from problem table.
Solved using: Python in Excel.
Compile Role Based Totals
Challenge No. 206: Generate the result table from problem table.
Solved using: Python in Excel.
Create a Detailed Table
Challenge No. 65: Create the Detailed table from the Summary
e.
Solved using: Python.
Pivot Yes No Percentages
Challenge No. 205: From tables T1 and T2, generate the result table.
Solved using: Python in Excel.
Decrypt Keyword Cipher Text
Challenge No. 471: Decrypt the Encrypted Text using Keyword Cipher.
Solved using: Python in Excel.
Sort Rows by Reference Column
Challenge No. 468: This challenge was posed by Sunny Baggu
List the rows from problem table as per column H.
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.