Challenge No. 640: Treat the data between two pluses as one group.
Solved using: R.
By Topic
Challenges categorized by topic.
Calculate Actual Task Durations
Challenge No. 631: This challenge has been contributed by Abdelrahman Omer, MBA, PMP.
Solved using: Python in Excel.
Find Immediate Previous Caller
Challenge No. 630: For each date group, populate the immediate last caller.
Solved using: Python in Excel.
Top Three Sales by Date
Challenge No. 624: Find the top 3 highest sales made on a date and list along with Customer Name and Date.
Solved using: Python in Excel.
Identify 2025 Palindromic Dates
Challenge No. 621: Dear Patrons,
=LET(n,”72658080893278698732896965823250485053″,CONCAT(CHAR(MID(n,SEQUENCE(LEN(n)/2,,,2),2))))
Find out which dates are Palindromic dates in year 2025.
Solved using: Python.
Schedule Tasks Using Dependencies
Challenge No. 618: Today’s challenge is contributed by Abdelrahman Omer, MBA, PMP.
Solved using: Python.
Rank Cities by Percent Change
Challenge No. 615: List the top 3 cities where sum of %change from 2020 to 2021 and 2021 to 2022 is the highest.
Solved using: Python.
Merge and Sort Name Rows
Challenge No. 606: Merge rows on the basis of names.
Solved using: Python.
Detect Possible Date Formats
Challenge No. 605: Out of 3 date formats only, MDY, DMY & YMD, list the date formats for given dates.
Solved using: Python.
Identify Missing Number Ranges
Challenge No. 603: Find the missing numbers in the grid given between the smallest and the largest numbers.
Solved using: Python.