Challenge No. 176: If a single name => name followed by “is in team”.
Solved using: Power Query.
MAP
Applies a function to each element of one or more arrays in Excel.
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).
Distribute Amount Monthly
Challenge No. 51: Distribute the amount over month-year for every item.
Solved using: Power Query (List.Transform).
Extract Last Odd Numbers
Challenge No. 174: Extract the last n odd numbers.
Solved using: Excel VBA.
XOR Cipher for Message
Challenge No. 173: This time, in step 3 in place of adding both the numbers, we need to do Bitwise XOR operation.
Solved using: Power Query (List.Transform).
Substring Repeat Detection
Challenge No. 171: A string can be made by repetitions of substrings.
Solved using: Excel VBA.
Reverse Prime Numbers
Challenge No. 170: Given is a list of prime numbers.
Solved using: Python in Excel.
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.
Uppercase Position Finder
Challenge No. 168: Find the positions of uppercase letters and separate them by dashes.
Solved using: Excel VBA.
Merge! Part 2
Challenge No. 124: In Question Table 1, dates and prices for a product are provided.
Solved using:Excel (INDEX, LAMBDA, LET), Google Sheets, Power Query (Table.AddColumn), Python, Python in Excel, and R.