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.
SORT
Sorts an array in ascending or descending order 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.
Count Team Wins
Challenge No. 46: List the Teams and the number of matches won by them.
Solved using: Python in Excel.
Find Last Group of Missing Numbers
Challenge No. 42: Provide a formula to find last group of missing numbers.
Solved using: Power Query.
Custom Ranking!
Challenge No. 85: In the Question Table, values are provided and we want to rank them in ascending order based on custom logic.
Solved using:Excel (FILTER, HSTACK, IF), Power Query (List.Sort, List.Transform), Python, and R.
Top Scorers by Subject
Challenge No. 20: List the distinct Subjects and Students who have scored the highest marks in those subjects along with Marks scored by them.
Solved using: Python in Excel.
Avg Delivery Time
Challenge No. 75: In the Question table, the order date for different products is provided (determined by positive quantity).
Solved using:DAX, Excel (CHOOSECOLS, FILTER, HSTACK), Power Query (Table.AddColumn, Table.Group, Table.SelectRows), Python, R, and SQL.
Process Efficiency!
Challenge No. 56: In Question Table 2, the sequence of machinery based on the process type is presented, and historical machinery data is provided in Question Table 1.
Solved using:Excel, and Power Query.
Oeis Sequence
Challenge No. 53: The On-Line Encyclopedia of Integer Sequences presents several number sequences based on specific rules.
Solved using:Excel (FILTER, LAMBDA, LEFT), Power Query (List.Transform), Python, and R.