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.
HSTACK
Stacks arrays horizontally into a single row in Excel.
Even-Odd Reversed Squares
Challenge No. 678: Find first 50 numbers (at least 2 digits) where
1.
Solved using: Python.
Quarterly Payment Grouping
Challenge No. 676: Today’s challenge is contributed by 🇰🇷 Taeyong Shin
Divide the payments among different quarters / months.
Solved using: R.
Signed Permutation Generator
Challenge No. 675: This problem is contributed by Sunny Baggu
Given 2 input numbers, create all possible permutations considering numbers as both positive and negative.
Solved using: Python.
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.
Transpose Table With Profit
Challenge No. 670: Transpose the table as shown.
Solved using: Python.
Pivot Data To Columns
Challenge No. 667: Pivot the data as shown.
Solved using: Python.
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.
Pivot Hierarchical Sublevels
Challenge No. 663: Pivot the data as shown.
Solved using: Power Query.
Insert Yearly Sum Totals
Challenge No. 660: Insert the sum for the year after the year ends.
Solved using: Python.