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.
Perfect Square And Cube
Challenge No. 648: List the first 20 numbers which are both perfect square and perfect cube.
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.
Wrap Rows By Number Gaps
Challenge No. 641: Extend the given numbers into row and wrap the row where absolute gap between two subsequent numbers is greater than 2.
Solved using: R.