Challenge No. 233: Calculate the Shipped and Non-shipped amounts (Quantity * Price) for all Fruits.
Solved using: Python.
LET
Assigns names to values or calculations to simplify formulas in Excel.
Pair Swipes
Challenge No. 73: Pair the staff Swipes.
Solved using: R.
List Dates with Unique Digits
Challenge No. 521: List all dates containing unique digits between 1900-01-01 to 2999-12-31.
Solved using: Python in Excel.
Align Rowwise Data
Challenge No. 520: Align the data as given in answer expected.
Solved using: Python in Excel.
Repeat Rows Until Next Date
Challenge No. 232: Repeat a row till the next date.
Solved using: Python in Excel.
Matching Digit Sums
Challenge No. 519: Find first 25 numbers starting with two digits where sum of individual digits of (Number = Square of Number = Cube of Number)
Ex.
Solved using: Python.
Rank by Student Grade
Challenge No. 518: Rank the students on the basis of grades.
Solved using: Python.
Quantity Times Price Total
Challenge No. 231: Pivot the problem tables into result table.
Solved using: Python in Excel.
Perfect Square Predecessor Checker
Challenge No. 517: Arrange the given numbers in such a fashion that sum of preceding + current number is a perfect square.
Solved using: Python 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.