Challenge No. 629: If a number is preceded by + or -, change + to – and – to +.
Solved using: Python.
LET
Assigns names to values or calculations to simplify formulas in Excel.
Calculate Cheapest Bottle Combination
Challenge No. 628: Today’s challenge is contributed by Mehmet Çiçek.
Solved using: R.
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.
Sum Numbers in Zigzag Path
Challenge No. 623: Find the sum of numbers traversing the diagonal from first column to second column to third column to second column to first column and repeating it till the end.
Solved using: R.
List Words with Three Vowels
Challenge No. 622: Generate the list of words which contain at least 3 different vowels.
Solved using: R.
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.
Generate Sequential Ticket Numbers
Challenge No. 620: Create the ticket numbers for each State.
Solved using: Python.
Top 3 Salespersons per Quarter
Challenge No. 619: List the top 3 salespersons for every quarter on the basis of total sales in that quarter.
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.