Challenge No. 123: Column A contains list of US presidents.
Solved using: SQL.
SORTBY
Sorts an array based on the values in another array in Excel.
Custom Rank! Part 1
Challenge No. 106: Rank the countries based on Olympic medals, starting with the number of gold medals.
Solved using:Excel, Power Query, Python, and R.
Reverse Rows and Columns
Challenge No. 108: Reverse the rows and columns both.
Solved using: SQL.
Random Selection! Part 2
Challenge No. 99: Randomly select 4 unique staff members using the following procedure:
1- Randomly select a department out of 5 departments with equal probability.
Solved using:Excel, Power Query, and R.
Reverse Words in String
Challenge No. 82: Reverse the Words in the string.
Solved using: SQL.
Random Selection! Part 1
Challenge No. 93: Randomly select a staff member from each department.
Solved using:Excel (FILTER, HSTACK, INDEX), Google Sheets, Power Query (Table.Group), Python, Python in Excel, and R.
Top Three Students Report
Challenge No. 15: (Excel formulas also welcome)
Generate Top 3 students in all subjects.
Solved using: Power Query.
Sort Cities on Reversed Prefix
Challenge No. 48: Sort (case insensitive) the cities on the basis of first word of the city names and sorting should be done on the basis of first word read backward i.
Solved using: Power Query (Table.AddColumn, Table.Sort).
Sales Per Customer
Challenge No. 61: In Question Table 1, sales transactions are provided.
Solved using:Excel (FILTER, HSTACK, IF), Power Query (Table.Group, Table.Sort), Python, R, and VBA.
Sort Table Columns
Challenge No. 43: In the question table (Product sales in different regions), sort the columns in descending order based on their total values.
Solved using:Excel (BYCOL, HSTACK, LAMBDA), Google Sheets, Power Query (List.Skip, Table.Column, Table.ColumnNames), Python, and R.