Challenge No. 581: Populate 1 in first group of As and for every succeeding group of As, add 1 to the count.
Solved using: Python.
DROP
Removes a specified number of rows or columns from an array in Excel.
Summarise the table with total
Challenge No. 266: Summarise the table as shown with a total row after each sales person’s data.
Solved using: Python.
Populate the addresses for Greek
Challenge No. 264: Populate the addresses for Greek alphabets appearing in the grid.
Solved using: Python in Excel.
Rank stores by percentage of
Challenge No. 263: Table 1 (T1) has got customer satisfaction responses and Table 2 (T2) has got color coding of those responses.
Solved using: Python.
Transpose the given data from
Challenge No. 261: Transpose the given data from Problem Table into Result table as shown.
Solved using: Python in Excel.
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.
Count Bands by Product Range
Challenge No. 563: List the products, range of numbers along with the count of bands (not count of product).
Solved using: Python.
Maximum Profit from Transactions
Challenge No. 561: For each row, you need to buy first and sell second.
Solved using: Python in Excel.
Pivot the problem table into
Challenge No. 251: Pivot the problem table into result table.
Solved using: Python.
Calculate Finish Stock and Starting
Challenge No. 250: Calculate Finish Stock and Starting Stock.
Solved using: Python.