Challenge No. 518: Rank the students on the basis of grades.
Solved using: Python.
IF
Returns one value for TRUE and another for FALSE based on a condition in Excel.
Sum Sales By Month
Challenge No. 230: Summarize the table as shown by summing up Sales against each month.
Solved using: Python in Excel.
Normalize Tabular Data
Challenge No. 515: Normalize the data given in columns A to B as given in Answer Expected.
Solved using: Python.
Max 2×2 Grid Sum
Challenge No. 514: Find the 2×2 grids in the given 5×5 grid where sum is the maximum.
Solved using: Python in Excel.
Clean Salary and Promotion Data
Challenge No. 226: Clean the given data and align them properly in departments and sort on Dept ID & Names.
Solved using: Python in Excel.
Reshape Wide Table Format
Challenge No. 224: 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.
Aggregate Customer Purchase Stats
Challenge No. 503: Today’s challenge is contributed by 🇰🇷 Taeyong Shin
Calculate the sum, average, maximum value, minimum value, count, and payment amount for products purchased by each customer.
Solved using: Python 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.