Challenge No. 574: Keep the numbers in even positions as it is and sort the numbers in odd positions.
Solved using: R.
CONCAT
Concatenates text from multiple cells without a delimiter 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.
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.
Odd Numbers All Directions
Challenge No. 550: Last week, we had this challenge.
Solved using: Python in Excel.
Odd Numbers in Matrix
Challenge No. 546: List the odd numbers reading rows from left to right and columns from top to bottom.
Solved using: Python.
Rank Players by Uppercase
Challenge No. 545: There are 6 players (q, w, e, r, t, y) and if a player wins, it appears in upper case and if it loses, then it appears in lower case.
Solved using: Python.
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.
List WC Champion Years
Challenge No. 498: Align the soccer WC champions year wise (year in descending order).
Solved using: Python in Excel.