Challenge No. 652: Generate the ticket numbers as given.
Solved using: Python.
LAMBDA
Creates custom reusable functions in Excel.
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.
Bottom Three Unique Values
Challenge No. 650: List the bottom 3 unique values across the columns.
Solved using: Python.
Running Total With Reset
Challenge No. 649: Calculate the running total for each group.
Solved using: Python.
Pattern Recognition Generator
Challenge No. 647: Understand the pattern and generate it.
Solved using: Python.
Insert Quarterly Totals
Challenge No. 646: Insert Quarterly total line after Mar, Jun, Jul and Dec.
Solved using: Python in Excel.
Align WBS Hierarchy Data
Challenge No. 645: Today’s challenge is contributed by Ahmad Syawal Ramli.
Solved using: Python.
Names With Total Costs
Challenge No. 644: List All names and total cost against each name.
Solved using: R.
Swap Number Sequences
Challenge No. 643: Replace next set of numbers with previous set of numbers and first set of numbers will be replaced by last set of numbers.
Solved using: Python in Excel.
List Alphabet And Numbers
Challenge No. 642: List all consecutive alphabets in Data column separated by comma.
Solved using: Excel VBA.