Challenge No. 543: Find out the top 2 salaries in all departments.
Solved using: Python in Excel.
UNIQUE
Returns unique values from a range or array in Excel.
Sum and Sort Student Marks
Challenge No. 244: Merge both problem tables into one by summing marks for common entries.
Solved using: Python.
Exclude Weekend Leave Days
Challenge No. 234: Find the total leaves taken by the employees.
Solved using: Python.
Pair Swipes
Challenge No. 73: Pair the staff Swipes.
Solved using: R.
List Dates with Unique Digits
Challenge No. 521: List all dates containing unique digits between 1900-01-01 to 2999-12-31.
Solved using: Python in Excel.
Rank by Student Grade
Challenge No. 518: Rank the students on the basis of grades.
Solved using: Python.
Shift Rows into Columns
Challenge No. 225: Transpose the problem table into result table.
Solved using: Python.
List Subject Pass Students
Challenge No. 222: Marks for various tests are given in problem table.
Solved using: R.
Extract and Group
Challenge No. 70: Extract the Departments and their Sub-department
Department name is before the 1st hyphen
Solution should be in a Cross-tab as shown
Dynamic array function allowed but Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: R.
Find Row/Col Consecutive Numbers
Challenge No. 501: In the given grid, find the numbers which are consecutive either column wise or row wise (not diagonal wise).
Solved using: Python.