Challenge No. 693: Generate a sequence taking first 4 numbers as 1, 2, 3, 4.
Solved using: Python.
REDUCE
Reduces an array to a single value using an accumulator function in Excel.
Split And Sum Orders
Challenge No. 682: In the problem table, if there are more than one order number, then amount will be equally divided among order numbers.
Solved using: Python.
Split And Align Columns
Challenge No. 681: Split and align the data as shown.
Solved using: Python in Excel.
Distribute Consecutive Numbers
Challenge No. 674: This challenge has been contributed by Mehmet Çiçek
List consecutive numbers into different columns.
Solved using: Python in Excel.
Track Quality Test Rounds
Challenge No. 664: After 3 rounds of quality testing, list the remaining batches from Round0 after each Round.
Solved using: Python in Excel.
Generate Sequential Tickets
Challenge No. 652: Generate the ticket numbers as given.
Solved using: Python.
Running Total With Reset
Challenge No. 649: Calculate the running total for each group.
Solved using: Python.
Align WBS Hierarchy Data
Challenge No. 645: Today’s challenge is contributed by Ahmad Syawal Ramli.
Solved using: Python.
Generate Unique Day Abbreviations
Challenge No. 638: Given are Day of week names in 3 languages.
Solved using: Excel VBA.
List Words with Three Vowels
Challenge No. 622: Generate the list of words which contain at least 3 different vowels.
Solved using: R.