Challenge No. 603: Find the missing numbers in the grid given between the smallest and the largest numbers.
Solved using: Python.
MIN
Returns the smallest value in a range in Excel.
Maximum Profit from Transactions
Challenge No. 561: For each row, you need to buy first and sell second.
Solved using: Python in Excel.
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.
Exclude Weekend Leave Days
Challenge No. 234: Find the total leaves taken by the employees.
Solved using: Python.
Aggregate Customer Purchase Stats
Challenge No. 503: Today’s challenge is contributed by 🇰🇷 Taeyong Shin
Calculate the sum, average, maximum value, minimum value, count, and payment amount for products purchased by each customer.
Solved using: Python in Excel.
Convert List to Integer Intervals
Challenge No. 486: Generate the integer intervals corresponding to given numbers.
Solved using: Python in Excel.
Sort Rows by Reference Column
Challenge No. 468: This challenge was posed by Sunny Baggu
List the rows from problem table as per column H.
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.
Weekday Weekend Sales Report
Challenge No. 170: Calculate the sum of sale for Weekdays and Weekends.
Solved using: Python in Excel.
Find Missing Letters in Range
Challenge No. 353: Find the missing letters.
Solved using: R.