Challenge No. 574: Keep the numbers in even positions as it is and sort the numbers in odd positions.
Solved using: R.
SEQUENCE
Generates a sequence of numbers in an array in Excel.
Weekly Count by Category
Challenge No. 572: Week 1 starts from 1st of the month.
Solved using: Python in Excel.
Digit-Constrained Product Numbers
Challenge No. 571: Find the first 500 numbers starting with 10 where number multiplied by its reversed digits contain only those digits which are there in the number.
Solved using: Python.
Absolute Alphabet Frequency Difference
Challenge No. 569: Find the count of alphabets in String1 and String2 and take the absolute difference of count of common alphabets and retain the non-common ones, combine those alphabets along with their counts (sorted alphabetically).
Solved using: Python in Excel.
Expand Alphabet Letter Gaps
Challenge No. 568: Fill in the missing letters between two letters in the given words.
Solved using: Python.
Assign Fruits to Tiers
Challenge No. 566: Populate Fruits1, Fruits2 and Fruits3 against fruits beneath the counts.
Solved using: Python.
Reversed Even Perfect Squares
Challenge No. 565: Find first 50 numbers where both the number and its reversed number are
– Even
– Perfect squares
Ex.
Solved using: Python in Excel.
Palindrome One-Child Numbers
Challenge No. 562: One Child Palindromes – Find all unique substrings of a number excluding 0 and if one and only one substring is divisible by the length of the number, then this is called One Child number.
Solved using: Python.
Find Vowels Between Consonants
Challenge No. 560: Locate the vowels which are between two consonants.
Solved using: Python.
Build Cumulative Triangle Grid
Challenge No. 556: Generate this triangle where bottom row starts with 1 and all rows contain numbers which are cumulative sum from 1 to A1.
Solved using: Python in Excel.