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.
LAMBDA
Creates custom reusable functions in Excel.
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.
Count Consecutive Number Repeats
Challenge No. 614: Today’s challenge is contributed by Mehmet Çiçek.
Solved using: R.
Generate Sum of Digits Sequence
Challenge No. 613: Sum of Digits Sequence – It starts with 1 and every succeeding term is sum of all digits appearing previously.
Solved using: Excel VBA.
Match Names with Same Initials
Challenge No. 612: List the names if first character of first name and first character of last name are same.
Solved using: Python.
Find Maximum N-Digit Grid Number
Challenge No. 611: Find the N digit maximum number in given 6×6 grid either rows (left to right) or columns (top to down).
Solved using: Python.