Challenge No. 264: Populate the addresses for Greek alphabets appearing in the grid.
Solved using: Python in Excel.
HSTACK
Stacks arrays horizontally into a single row in Excel.
Calculate Name-Based Durations
Challenge No. 573: Work out the durations in hours against all names.
Solved using: Python.
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.
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.
Generate the result table from
Challenge No. 256: Generate the result table from problem tables.
Solved using: R.
Maximum Profit from Transactions
Challenge No. 561: For each row, you need to buy first and sell second.
Solved using: Python in Excel.