Challenge No. 658: Word Square – A word square is a n x n matrix where row (i) = column (i).
Solved using: Python.
LET
Assigns names to values or calculations to simplify formulas in Excel.
Largest Alternating Digit Substring
Challenge No. 657: Find the largest substring number which has alternating odd/even or even/odd digits.
Solved using: R.
Find Project Critical Path
Challenge No. 656: This challenge is contributed by Abdelrahman Omer, MBA, PMP
Find the critical path and its duration for this project.
Solved using: Python.
Detect Sequence Direction
Challenge No. 655: Find whether a sequence is increasing (I), decreasing (D) or neither of these (N).
Solved using: Python.
Percentage Share Per Group
Challenge No. 654: Work out the % Revenue share of each year within a group where % = Revenue / Sum of Revenue of a Group.
Solved using: Python in Excel.
Last Sundays Of Year
Challenge No. 653: List the last Sundays of the all 12 months of year given in cell A2.
Solved using: Python in Excel.
Generate Sequential Tickets
Challenge No. 652: Generate the ticket numbers as given.
Solved using: Python.
Create Vortex Number Grid
Challenge No. 651: This challenge is contributed by Mehmet Çiçek
Create the vortex grid of numbers (n x n) for a value given in column A.
Solved using: Python in Excel.
Running Total With Reset
Challenge No. 649: Calculate the running total for each group.
Solved using: Python.
Perfect Square And Cube
Challenge No. 648: List the first 20 numbers which are both perfect square and perfect cube.
Solved using: Python.