Challenge No. 683: Find the value corresponding to numbers given in column N from the grid given of left hand side.
Solved using: Python.
LAMBDA
Creates custom reusable functions 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.
Last Selected Queue Item
Challenge No. 679: For production runs, number of items (say N) to be selected in one go is given in every column.
Solved using: Python.
Even-Odd Reversed Squares
Challenge No. 678: Find first 50 numbers (at least 2 digits) where
1.
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.
Draw Star Shape Pattern
Challenge No. 673: Create the star patterns for given N.
Solved using: R.
Calculate Level Hierarchy Totals
Challenge No. 672: Level 1 is sum of Level 2.
Solved using: R.
Word Pairs With All Vowels
Challenge No. 671: Find the pair of words which together contain all 5 vowels.
Solved using: Python in Excel.
Transpose Table With Profit
Challenge No. 670: Transpose the table as shown.
Solved using: Python.