Challenge No. 327: List the top 3 marks and names and subjects against them.
Solved using: Python in Excel.
SORT
Sorts an array in ascending or descending order in Excel.
Top 3 employees nearest to average salary
Challenge No. 322: Find the top 3 employees whose salary is nearest to average salary.
Solved using: DAX.
Extracting Whole Route
Challenge No. 53: Generate a whole route for the airlines
e.
Solved using: R.
Rank by Best of 3 Subjects
Challenge No. 106: Generate the result table from problem table.
Solved using: Power Query.
Words in Alphabetical Order
Challenge No. 293: Provide a formula to list all words from A2:A10 where English alphabets appear in alphabetical order.
Solved using: Python in Excel.
Performance!
Challenge No. 172: In this challenge, 250,000 rows of hourly historical data are provided, which are not sorted in any specific order.
Solved using:Excel (DROP, LET, SORT), Google Sheets, Power Query (Table.AddColumn, Table.Sort), Python, Python in Excel, and R.
Group Words by Anagrams
Challenge No. 282: An anagram is a word which is made by arranging the letters of another word.
Solved using: Python in Excel.
Find Divisible Substrings Sorted
Challenge No. 281: List all the substrings from Number1 which are divisible by Number2.
Solved using: Python in Excel.
Filter Last Transaction!
Challenge No. 158: From the question table, extract the last transaction per product for each month.
Solved using:Excel (DROP, FILTER, GROUPBY), Google Sheets, Power Query (Date.Month, Table.AddColumn, Table.Combine), Python, Python in Excel, and R.
Digit Rearranged Multiplication Match
Challenge No. 251: Find those numbers which when multiplied by 2 to number of digits in that number generates the same digits in any other order.
Solved using: Power Query.