Challenge No. 518: Rank the students on the basis of grades.
Solved using: Python.
SEQUENCE
Generates a sequence of numbers in an array in Excel.
Smallest Product Digit Number
Challenge No. 516: Find the smallest numbers whose product of digits is equal to numbers in column A.
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.
Sum Pascal Triangle Columns
Challenge No. 509: A Pascal Triangle starts with 1 at the top and each element is sum of two upper diagonal cells.
Solved using: R.
Perfect Square with Digit-Square Sum
Challenge No. 508: List first 500 numbers (skip single digit numbers) where number is a perfect square and also sum of squares of its digits is also a perfect square.
Solved using: Python in Excel.
Interleave Numbers into Letters
Challenge No. 506: Concat column B numbers into column 1 alphabets.
Solved using: Python.
List Subject Pass Students
Challenge No. 222: Marks for various tests are given in problem table.
Solved using: R.
Draw Alphabet Triangle
Challenge No. 505: Draw the triangle of alphabets as shown.
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.
Generate Lynch Bell Numbers
Challenge No. 499: Lynch Bell Numbers – Generate the first 500 Lynch Bell Numbers starting with 2 digits.
Solved using: Excel VBA.