Challenge No. 544: Extract the first and last set of numbers appearing in A2:A10 and sum them.
Solved using: R.
Top Two Department Salaries
Challenge No. 543: Find out the top 2 salaries in all departments.
Solved using: Python in Excel.
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.
Create Text-Based Square
Challenge No. 542: Generate the given squares from the given strings.
Solved using: Excel VBA.
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.
Get names in a sorted
Challenge No. 245: Get names in a sorted order under subject columns.
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.
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.
Sum and Sort Student Marks
Challenge No. 244: Merge both problem tables into one by summing marks for common entries.
Solved using: Python.
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.