Challenge No. 544: Extract the first and last set of numbers appearing in A2:A10 and sum them.
Solved using: R.
LET
Assigns names to values or calculations to simplify formulas in Excel.
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.
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.
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.