Challenge No. 218: Transpose the table as shown.
Solved using: Python in Excel.
ARRAYTOTEXT
Converts an array to text in Excel.
Max Consecutive Number Streak
Challenge No. 451: Find the positive and negative numbers which occur consecutively maximum number of times.
Solved using: Python in Excel.
Generate Look-and-Say Sequence
Challenge No. 444: Look & Say Sequence
Going from Left to Right in a number, take a digit and insert how many times this digit appears to the left of the digit.
Solved using: Python in Excel.
Generate Integers From Ranges
Challenge No. 441: Generate the integers corresponding to intervals.
Solved using: Python.
Count Unique Letters in String
Challenge No. 399: Extract the unique alphabets from the given strings and count their frequencies of occurrence.
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.
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.
Find missing terms in arithmetic progressions
Challenge No. 325: Find the missing terms in Arithmetic Progressions given.
Solved using: Python in Excel.
Extract From Text! Part 7
Challenge No. 169: Similar to Challenge 149, extract the texts between the pairs of the characters listed below.
Solved using:Excel (ARRAYTOTEXT, LAMBDA, MAP), Google Sheets, Power Query (List.Split, List.Transform, Text.Combine), Python, Python in Excel, and R.
Find Monthly Min Max Dates
Challenge No. 99: Find when the Min and Max occurred for various months and corresponding dates.
Solved using: Power Query (Text.Combine).