Challenge No. 542: Generate the given squares from the given strings.
Solved using: Excel VBA.
MID
Extracts a substring from a text string at a given position in Excel.
List All Emirp Numbers
Challenge No. 538: An emirp (prime spelled backward = emirp) number is a prime number and its reversal is also a prime number but this is not a palindromic prime.
Solved using: Python in Excel.
Next Palindrome with Repeats
Challenge No. 534: Find the next 3 Palindrome numbers for the given numbers where any digit is repeated by the numbers given in Repeats column.
Solved using: Python in Excel.
Index-wise Base Encoding Sort
Challenge No. 527: Convert every digit from right to left in the base of its index + 1 reading index 1, 2.
Solved using: Python.
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.
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.
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.
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.
Check Lexically Sorted Dates
Challenge No. 507: List the dates which are lexically sorted.
Solved using: Python.
Remove Digits for Largest Cube
Challenge No. 502: For the largest cube number by removing minimum number of digits.
Solved using: Python in Excel.