Challenge No. 700: Pivot the given data by summing up the values.
Solved using: Python.
CHOOSECOLS
Returns specific columns from an array in Excel.
Team with All Wins
Challenge No. 692: List the team which won all their matches.
Solved using: Python in Excel.
Sum of Values for Alphabets
Challenge No. 690: The value associated with alphabets are given in the grid next to the alphabets.
Solved using: Python in Excel.
Transpose Table With Profit
Challenge No. 670: Transpose the table as shown.
Solved using: Python.
List the fruits and the
Challenge No. 259: List the fruits and the sum of total amount against a fruit.
Solved using: Python in Excel.
Prepare the result table on
Challenge No. 247: Prepare the result table on the basis of problem tables 1 & 2.
Solved using: Python.
Top Two Department Salaries
Challenge No. 543: Find out the top 2 salaries in all departments.
Solved using: Python in Excel.
For each Deal, list the
Challenge No. 246: For each Deal, list the name of the persons who handled the deal most recently.
Solved using: Python.
Sum Sales By Month
Challenge No. 230: Summarize the table as shown by summing up Sales against each month.
Solved using: Python in Excel.
Clean Salary and Promotion Data
Challenge No. 226: Clean the given data and align them properly in departments and sort on Dept ID & Names.
Solved using: Python in Excel.