Challenge No. 267: Work out the running total for first 10 entries, then next 9 entries, then next 8 entries till you reach 1 entry.
Solved using: Python.
IF
Returns one value for TRUE and another for FALSE based on a condition 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.
Sort Consonants Keep Vowels
Challenge No. 576: Sort the consonants in given sentences while keeping the vowels wherever they are.
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.
Weekly Count by Category
Challenge No. 572: Week 1 starts from 1st of the month.
Solved using: Python in Excel.
Assign Fruits to Tiers
Challenge No. 566: Populate Fruits1, Fruits2 and Fruits3 against fruits beneath the counts.
Solved using: Python.
Sort Only Numeric Columns
Challenge No. 564: Sort the columns where only numbers will be sorted and non-numbers will not be sorted.
Solved using: R.
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.