Challenge No. 530: Find the dates when maximum sales was made for a person and also list the corresponding amount.
Solved using: Python.
MAX
Returns the largest value in a range in Excel.
Exclude Weekend Leave Days
Challenge No. 234: Find the total leaves taken by the employees.
Solved using: Python.
Max 2×2 Grid Sum
Challenge No. 514: Find the 2×2 grids in the given 5×5 grid where sum is the maximum.
Solved using: Python in Excel.
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.
Max Frequency Characters
Challenge No. 487: Find the characters whose frequency is the maximum and also find the maximum frequency.
Solved using: Excel VBA.
Convert List to Integer Intervals
Challenge No. 486: Generate the integer intervals corresponding to given numbers.
Solved using: Python in Excel.
Add Task Duration to Start
Challenge No. 209: Populate the End dates against all owners in a pivot format as shown.
Solved using: Python.
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.
Fill Missing Cells with Max
Challenge No. 462: Fill in the blanks with max from the immediate surrounding cells.
Solved using: Python in Excel.
Longest Uppercase Substring
Challenge No. 458: Extract the substrings which have longest sequence of capital (uppercase) letters in given words.
Solved using: Python.