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.
By Difficulty
Challenges categorized by difficulty level.
Extract and Format a Text String
Challenge No. 8: Extract and format the voucher number
Strictly Legacy array function or PQ
Nelson Mwangi.
Solved using: Power Query.
Create Number Blocks From a Text String
Challenge No. 11: Create blocks based on the sets of text number strings.
Solved using: Power Query.
Sum Tenure of US Presidents
Challenge No. 51: Provide a formula to calculate the total (sum) years of tenure of all US presidents.
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.
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.
Top Three Students Report
Challenge No. 15: (Excel formulas also welcome)
Generate Top 3 students in all subjects.
Solved using: Power Query.
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).
Return a Date given the Month, Year, Day of the Week and Occurrence
Challenge No. 7: Return a Date given the Month, Year, Day of the Week and Occurrence Strictly Legacy Array Functions or PowerQuery.
Solved using: Power Query.
Split and Sum a Text String Using a Criteria
Challenge No. 10: Sum only quantities above 100
Strictly use the Legacy array function or Power Query.
Solved using: Power Query.