Challenge No. 543: Find out the top 2 salaries in all departments.
Solved using: Python in Excel.
LAMBDA
Creates custom reusable functions in Excel.
Create Text-Based Square
Challenge No. 542: Generate the given squares from the given strings.
Solved using: Excel VBA.
For each Deal, list the
Challenge No. 246: For each Deal, list the name of the persons who handled the deal most recently.
Solved using: Python.
Five-Weekend Month Finder
Challenge No. 541: List the months and years having 5 Fridays, 5 Saturdays and 5 Sundays in a month for the years 2000 to 2999.
Solved using: Python in Excel.
Find Triangle with Given Area
Challenge No. 540: Find the perpendicular and base for a right angled triangle where Hypotenuse and Area are given.
Solved using: Python in Excel.
Get names in a sorted
Challenge No. 245: Get names in a sorted order under subject columns.
Solved using: Python in Excel.
Compute Average Supplier Price
Challenge No. 539: Table1 gives the Items, Suppliers and per unit rate for different band of quantities.
Solved using: Python in Excel.
List All Emirp Numbers
Challenge No. 538: An emirp (prime spelled backward = emirp) number is a prime number and its reversal is also a prime number but this is not a palindromic prime.
Solved using: Python in Excel.
Sum and Sort Student Marks
Challenge No. 244: Merge both problem tables into one by summing marks for common entries.
Solved using: Python.
Find Min Product of Three
Challenge No. 537: Find the minimum product which results from multiplying any 3 numbers from N1 to N6.
Solved using: Python in Excel.