Challenge No. 613: Sum of Digits Sequence – It starts with 1 and every succeeding term is sum of all digits appearing previously.
Solved using: Excel VBA.
SEQUENCE
Generates a sequence of numbers in an array in Excel.
Find Maximum N-Digit Grid Number
Challenge No. 611: Find the N digit maximum number in given 6×6 grid either rows (left to right) or columns (top to down).
Solved using: Python.
Find Missing AP Sequence
Challenge No. 609: The first and last terms in an Arithmetic Progressions (AP) are given in each row.
Solved using: Python in Excel.
Identify Missing Number Ranges
Challenge No. 603: Find the missing numbers in the grid given between the smallest and the largest numbers.
Solved using: Python.
Transpose table, compute gross profit
Challenge No. 278: Transpose the table as shown where sum of amount shown is gross profit which is Revenue – Cost.
Solved using: Python.
Count Alphabetically Sorted Words
Challenge No. 601: Find the count of words in columns A through C if the words have sorted alphabets.
Solved using: Python in Excel.
Find Smallest Uncreatable Sum
Challenge No. 600: What is the smallest sum which you can’t create using all or few of the coins given?
Ex.
Solved using: Python in Excel.
Find Step Harshad Palindromes
Challenge No. 598: List Palindromic Step Harshad numbers less than 10 million starting with double digit numbers.
Solved using: Python in Excel.
Calculate Monthly Day Totals
Challenge No. 595: This challenge is contributed by 🇰🇷 Taeyong Shin
Create a table that calculates the number of weekdays, Saturdays, and Sundays using yearly and monthly data, and displays the total number of days in each month.
Solved using: Python in Excel.
Reapply Original Capitalization
Challenge No. 594: Work out the indexes where capital letters are.
Solved using: Python in Excel.