Challenge No. 205: From tables T1 and T2, generate the result table.
Solved using: Python in Excel.
ROW
Returns the row number of a reference in Excel.
Evaluate Concatenated Math Rows
Challenge No. 472: All rows carry one mathematical operator (to simplify only 4 basic maths operators which are +, -, * and / ).
Solved using: Python in Excel.
Mark Overlapping Time Ranges
Challenge No. 467: If tasks’ From Time and To Time overlap with each other, mark them as Y.
Solved using: Python in Excel.
Task Assignment Load Balancing
Challenge No. 465: There are 4 persons who can be a candidate to do a task.
Solved using: Python in Excel.
Map Buyer Purchase Dates
Challenge No. 201: List what items each of the buyers bought? Table2 is for availability dates of the items during which items could have been bought.
Solved using: Python in Excel.
Common Entries and Count
Challenge No. 453: Today’s challenge is contributed by Mehmet Çiçek
Find the common entries in List1 and List2 and common count.
Solved using: Excel VBA.
Find Penholodigital Squares
Challenge No. 447: Penholodigital squares are perfect square numbers that contain digits from 1 to 9 exactly once.
Solved using: R.
Delete Duplicate Rows
Challenge No. 58: Delete rows with duplicate Invoice, User & Dept, whose values can be completely Offset.
Solved using: Python.
Find Birds in Grid Rows
Challenge No. 443: Given 10×10 grid in A2:K11 contains bird names across rows (not in columns).
Solved using: Python in Excel.
Rank Regions by Yearly Scores
Challenge No. 431: Rank regions on the basis of values given for each year and list the regions for maximum occurrences of Rank 1, 2 and 3 in different years.
Solved using: Python in Excel.