Challenge No. 395: Coordinates for points are given in x, y format.
Solved using: DAX.
TEXTSPLIT
Splits a text string into an array based on delimiters in Excel.
Extract Numbers Inside Parentheses
Challenge No. 386: Extract the numbers from the string if ONLY numbers are contained within the parentheses.
Solved using: Python in Excel.
Extract Signed Numbers from Text
Challenge No. 383: Extract the unique positive and negative numbers if they are immediately preceded by either plus or minus sign.
Solved using: Python.
Numbers With Larger Successors
Challenge No. 379: List all the numbers where all succeeding numbers are larger than the number.
Solved using: Python.
Split on First Greater Sum
Challenge No. 378: Split the numbers into two parts where sum of first part is > sum of second part where it happens for the first time.
Solved using: R.
Fruit Pair Frequency Grid
Challenge No. 148: Generate the grid shown where count need to be populated at intersections of rows and columns.
Solved using: Python.
Perform Faro Shuffle Types
Challenge No. 369: Faro Shuffle – Divide the data in two equal parts (data will always be even, so two equal parts).
Solved using: DAX.
Extract Longest Alphanumeric Segment
Challenge No. 361: Separate out the largest sequences of English alphabets and numbers from the given strings.
Solved using: Python in Excel.
Build Dictionary Excluding Vowels
Challenge No. 357: Prepare dictionary entries from Key Value pairs.
Solved using: Python in Excel.
Find Missing Letters in Range
Challenge No. 353: Find the missing letters.
Solved using: R.