Challenge No. 144: Match the Acronyms given in column C against the words given in column A.
Solved using: SQL.
CONCAT
Concatenates text from multiple cells without a delimiter in Excel.
Sort with Custom Rules
Challenge No. 129: We had a sorting challenge recently.
Solved using: Power Query.
Add Spaces Between Types
Challenge No. 128: Insert a space whenever there is a transition from alphabet to number OR number to alphabet in the strings.
Solved using: SQL.
Reverse Concatenation Order
Challenge No. 120: Where Tn = T(n-2) & T(n-1) and & was concatenation operator.
Solved using: SQL.
Sort by Type and Case
Challenge No. 116: Sort the strings within the cells.
Solved using: SQL.
Lookup Unique Set of Duplicates
Challenge No. 27: Extract Products with a Unique Set of 3 Customers in the whole dataset
For Example, Product A & D has a duplicate set of the 3 customers Dynamic array function allowed but Extra marks for Legacy solutions
or PowerQuery Solution.
Solved using: Python in Excel.
Sum Word Lengths in Range
Challenge No. 111: Generate all the numbers between From and To.
Solved using: SQL.
Generate Concatenation Table
Challenge No. 110: Generate the result table.
Solved using: SQL.
Count Palindromes in Range
Challenge No. 107: Palindrome numbers are those which are same even when read from backwards.
Solved using: Python in Excel.
Characters Repetition!
Challenge No. 105: In the question table, where some passwords are provided, extract the 6 most commonly used characters across all the passwords and count their repetitions.
Solved using:Excel (CONCAT, FILTER, GROUPBY), Google Sheets, Power Query (List.Combine, List.Distinct, List.Transform), Python, Python in Excel, and R.