Challenge No. 700: Pivot the given data by summing up the values.
Solved using: Python.
TEXTSPLIT
Splits a text string into an array based on delimiters in Excel.
Sum Without First And Last
Challenge No. 688: Sum all the numbers given in column A except the first and last numbers in every cell.
Solved using: R.
Align Names With Amounts
Challenge No. 684: Align Name and amounts together as shown.
Solved using: R.
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.
Word Pairs With All Vowels
Challenge No. 671: Find the pair of words which together contain all 5 vowels.
Solved using: Python in Excel.
Detect Sequence Direction
Challenge No. 655: Find whether a sequence is increasing (I), decreasing (D) or neither of these (N).
Solved using: Python.
Generate Sequential Tickets
Challenge No. 652: Generate the ticket numbers as given.
Solved using: Python.
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.