Challenge No. 108: Reverse the rows and columns both.
Solved using: SQL.
ROWS
Returns the number of rows in an array or range in Excel.
Avg Cost Between City Pairs
Challenge No. 92: Find the average cost between the pair of cities.
Solved using: Python in Excel.
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.
Swap Alternate Rows
Challenge No. 81: Interchange the position of 1st row with 2nd, 3rd with 4th, 5th with 6th and so on.
Solved using: SQL.
Two-Column Text!
Challenge No. 94: In the question table, texts are provided for different groups.
Solved using:Excel (DROP, FILTER, HSTACK), Google Sheets, Power Query (List.Split, List.Transform, Table.ExpandTableColumn), Python, Python in Excel, and R.
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.
Custom Splitter (Part 3)!
Challenge No. 83: In the Question table, sales information, including dates, product names, and quantities, is provided in a single cell.
Solved using:Excel (IFERROR, LET, ROWS), Power Query (List.Transform, Text.Split, Table.FromRows), Python, Python in Excel, R, and SQL.
Diagonal Sum Difference
Challenge No. 14: Provide a formula to find the difference between sum of right diagonal and sum of left diagonal.
Solved using: Python in Excel.
Bottom-Up VLOOKUP Formula
Challenge No. 8: Provide a formula in E3 to perform VLOOKUP from bottom for city given in E2.
Solved using: Python in Excel.
Convex Hulls (Gift Wrapping Algorithm)!
Challenge No. 80: The Convex Hull Algorithm leads to the smallest convex area (Polygon) that includes all the points in the dataset.
Solved using:Excel, Python, and R.