Challenge No. 271: From first group, pick up top 1 on the basis of revenue, from second group, pick up top 2 and so on.
Solved using: Python in Excel.
UNIQUE
Returns unique values from a range or array in Excel.
Animal Park Presence Matrix
Challenge No. 586: List all animals and all parks.
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.
Digit-Constrained Product Numbers
Challenge No. 571: Find the first 500 numbers starting with 10 where number multiplied by its reversed digits contain only those digits which are there in the number.
Solved using: Python.
Assign Fruits to Tiers
Challenge No. 566: Populate Fruits1, Fruits2 and Fruits3 against fruits beneath the counts.
Solved using: Python.
Pivot the problem table into
Challenge No. 251: Pivot the problem table into result table.
Solved using: Python.
Transpose problem table into result
Challenge No. 249: Transpose problem table into result table.
Solved using: Python.
Rank Players by Uppercase
Challenge No. 545: There are 6 players (q, w, e, r, t, y) and if a player wins, it appears in upper case and if it loses, then it appears in lower case.
Solved using: Python.
Prepare the result table on
Challenge No. 247: Prepare the result table on the basis of problem tables 1 & 2.
Solved using: Python.