Table.Sort Archives

Assign Rank1 and Rank2

Challenge No. 691: Give the rank1 and rank2 as shown.
Solved using: Python.

Challenge No. 275: Transpose the problem table into result table where value is sum of Values from problem table.
Solved using: Python.

Challenge No. 266: Summarise the table as shown with a total row after each sales person’s data.
Solved using: Python.

Challenge No. 543: Find out the top 2 salaries in all departments.
Solved using: Python in Excel.

Challenge No. 240: Transpose the problem table into result table as shown.
Solved using: R.

Challenge No. 234: Find the total leaves taken by the employees.
Solved using: Python.

Challenge No. 226: Clean the given data and align them properly in departments and sort on Dept ID & Names.
Solved using: Python in Excel.

Challenge No. 212: Find the total commission of each sales person and sort it descending on total amount.
Solved using: Python.

Challenge No. 211: Append the groups one below the other and sort on Income descending, Name ascending within each group.
Solved using: R.

Challenge No. 60: Group the customers per month.
Solved using: Python.