Challenge No. 55: Provide a formula to generate the given grid.
Solved using: Power Query.
SEQUENCE
Generates a sequence of numbers in an array in Excel.
Find Last Mondays after 25th
Challenge No. 52: Provide a formula to list the Last Mondays of each month for a given year in A1 if Last Monday falls on a day > 25.
Solved using: DAX.
Create Number Blocks From a Text String
Challenge No. 11: Create blocks based on the sets of text number strings.
Solved using: Power Query.
Check Word Anagram Pair
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.
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.
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.