Challenge No. 322: Find the top 3 employees whose salary is nearest to average salary.
Solved using: DAX.
UNIQUE
Returns unique values from a range or array in Excel.
Custom Grouping! Part 17
Challenge No. 187: Group the rows until encountering a missing date.
Solved using:Excel (DROP, GROUPBY, IF), Google Sheets, Power Query (Table.Group, Table.AddColumn, Table.AddIndexColumn), Python, Python in Excel, and R.
Extracting Whole Route
Challenge No. 53: Generate a whole route for the airlines
e.
Solved using: R.
Match Dates!
Challenge No. 183: In the question table, the dates are provided in various formats.
Solved using:Excel (IFERROR, INDEX, LAMBDA), Google Sheets, Power Query (Text.Split, Table.Distinct, Table.TransformColumns), Python, Python in Excel, and R.
Summarize Hours by Role Title
Challenge No. 112: Generate the result table from problem table where Hours are summation for a particular role.
Solved using: Python in Excel.
Max Call Duration Pair
Challenge No. 298: Work our the pair of persons for whom the sum of call duration is the highest.
Solved using: Python in Excel.
Matches With Equal Goal Difference
Challenge No. 290: List the matches where goal difference is same.
Solved using: Python in Excel.
Custom Grouping! Part 15
Challenge No. 173: The Question table contains transactions recorded on different dates.
Solved using:Excel (HSTACK, LAMBDA, LET), Google Sheets, Power Query (Table.Group, Date.Month, Table.AddIndexColumn), 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.