Challenge No. 190: Find the unique pairs of numbers whose sum is the maximum.
Solved using: Python in Excel.
TEXTSPLIT
Splits a text string into an array based on delimiters in Excel.
Compare Odd Even Counts
Challenge No. 186: If odd numbers are less, then post odd numbers.
Solved using: Power Query (List.Transform).
Fill Arithmetic Progression
Challenge No. 182: Find the missing numbers in Arithmetic Progressions given.
Solved using: Python in Excel.
Name Team Statement
Challenge No. 176: If a single name => name followed by “is in team”.
Solved using: Power Query.
Common Words Between Sentences
Challenge No. 175: Find the common words between Sentence1 and Sentence 2 and sort the common words.
Solved using: Power Query (Text.Split).
Extract Last Odd Numbers
Challenge No. 174: Extract the last n odd numbers.
Solved using: Excel VBA.
Pad In The Middle!
Challenge No. 125: For the IDs in the table, insert zeros between the text and numbers to ensure that each ID has exactly 6 characters.
Solved using:Excel (CONCAT, ISNUMBER, LAMBDA), Google Sheets, Power Query (Text.Repeat, Table.AddColumn), Python, Python in Excel, and R.
Counting TextString
Challenge No. 42: Count Stalls Stocking either Apple or Kiwi
Dynamic array function allowed, but Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: Python.
Reverse Long Words
Challenge No. 161: If a word in sentence has length > Number, then reverse that word.
Solved using: Power Query (Text.Combine).
Remove Words by Index
Challenge No. 152: Remove the Words from column A as per index in column B.
Solved using: Excel VBA.