Challenge No. 50: An anagram is a word or phrase formed by rearranging the letters of a different word or phrase, using all the original letters exactly once.
Solved using: Power Query.
LET
Assigns names to values or calculations to simplify formulas in Excel.
Top Three Students Report
Challenge No. 15: (Excel formulas also welcome)
Generate Top 3 students in all subjects.
Solved using: Power Query.
Digits in Increasing Sequence
Challenge No. 49: Provide a formula to list those numbers in A2:A10 where every succeeding digit is >= previous digit.
Solved using: Python in Excel.
Sort Cities on Reversed Prefix
Challenge No. 48: Sort (case insensitive) the cities on the basis of first word of the city names and sorting should be done on the basis of first word read backward i.
Solved using: Power Query (Table.AddColumn, Table.Sort).
Longest Palindromic Word
Challenge No. 47: Palindromes are those words which are same even when read from backwards.
Solved using: Python in Excel.
Count Team Wins
Challenge No. 46: List the Teams and the number of matches won by them.
Solved using: Python in Excel.
Same Initial Letter Names
Challenge No. 45: Provide a formula to list the names where all words start with same alphabet.
Solved using: Power Query (Table.SelectRows).
Minimize Absolute Value Difference
Challenge No. 44: Find the numbers where absolute difference between Number1 and Number2 in a row is minimum.
Solved using: Python in Excel.
Table Transformation! Part 9
Challenge No. 89: Product sales information is provided in the question table.
Solved using:Excel (COUNTA, FILTER, HSTACK), Power Query (List.Transform, Table.SelectRows, Table.Skip), Python, Python in Excel, and R.
Find Last Group of Missing Numbers
Challenge No. 42: Provide a formula to find last group of missing numbers.
Solved using: Power Query.