Challenge No. 280: List the Teams which have never lost even a single game.
Solved using: Python in Excel.
IF
Returns one value for TRUE and another for FALSE based on a condition in Excel.
Reverse Only Vowels in Word
Challenge No. 279: Reverse only the vowels in the given words.
Solved using: Python in Excel.
Custom Grouping! Part 14
Challenge No. 168: The stock prices for the given dates are provided in the question table.
Solved using:Excel (IF, LAMBDA, LET), Google Sheets, Power Query (Table.Group, Table.AddIndexColumn, Table.ExpandTableColumn), Python, Python in Excel, and R.
Reduce to Single Digit by Difference
Challenge No. 278: Reduce the number to a single digit number by repeatedly subtracting the adjacent digits.
Solved using: Python in Excel.
Table Transformation! Part 19
Challenge No. 167: Transform the question structure into the result structure.
Solved using:Excel (FILTER, HSTACK, IF), Google Sheets, Power Query (List.Skip, List.Split, Table.AddColumn), Python, Python in Excel, and R.
Fill Grid With Left Values
Challenge No. 97: Fill in the grid with the immediate non-blank value on the left.
Solved using: Excel VBA.
Find Palindrome Words in Text
Challenge No. 275: A Palindrome word is that which is same even when read backwards.
Solved using: Python in Excel.
Compare Store1 vs Store2 Visits
Challenge No. 96: List Customer1 whose Store1 Visit Date Time is less than or equal to Store2 Visit Date Time if they visited Store2 also.
Solved using: Power Query (Table.SelectRows).
Custom Grouping! Part 13
Challenge No. 165: Based on monthly transactions, categorize each customer for each month into one of the following groups:
New: A customer who has never made a purchase in previous months.
Solved using:Excel (FILTER, HSTACK, IF), Google Sheets, Power Query (Table.Group, List.Difference, List.Distinct), Python, and R.
Remove Consecutive Repeated Digits
Challenge No. 269: Remove consecutive digits from the number.
Solved using: Excel VBA.