Challenge No. 222: Marks for various tests are given in problem table.
Solved using: R.
SORT
Sorts an array in ascending or descending order in Excel.
Remove Digits for Largest Cube
Challenge No. 502: For the largest cube number by removing minimum number of digits.
Solved using: Python in Excel.
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.
List WC Champion Years
Challenge No. 498: Align the soccer WC champions year wise (year in descending order).
Solved using: Python in Excel.
Outstanding Loan Day Count
Challenge No. 215: Assuming today’s date is 7-Sep-24, pivot the table as shown for Outstanding loans.
Solved using: Python in Excel.
Sort Zoo Records Alphabetically
Challenge No. 214: Align the data as per Zoo and sort them alphabetically.
Solved using: DAX.
Salesperson Commission Breakdown
Challenge No. 212: Find the total commission of each sales person and sort it descending on total amount.
Solved using: Python.
Group by Income Then Sort
Challenge No. 211: Append the groups one below the other and sort on Income descending, Name ascending within each group.
Solved using: R.
Score Matrix for Team Matches
Challenge No. 482: Prepare the given matrix from problem table.
Solved using: Python in Excel.
Next Larger Permutation
Challenge No. 470: Find the next number which is greater and made from arranging digits from that number.
Solved using: Python in Excel.