Challenge No. 122: Add Number1 and Number 2 together.
Solved using: Python in Excel.
MID
Extracts a substring from a text string at a given position in Excel.
Calculate Digital Root
Challenge No. 121: Calculate Digital root of the given numbers.
Solved using: Python in Excel.
Trim Underscores at Ends
Challenge No. 119: Remove the trailing and leading underscore characters.
Solved using: SQL.
Signed Binary to Decimal
Challenge No. 118: Convert binary numbers into decimal numbers.
Solved using: Python in Excel.
Sort by Type and Case
Challenge No. 116: Sort the strings within the cells.
Solved using: SQL.
Find Beautiful Binary Strings
Challenge No. 115: A binary string is beautiful if it contains both 0 & 1 alternately.
Solved using: SQL.
Sum Word Lengths in Range
Challenge No. 111: Generate all the numbers between From and To.
Solved using: SQL.
GADERYPOLUKI Cipher Apply
Challenge No. 109: GADERYPOLUKI Cipher
Column A needs to be changed on the basis of key given in column B.
Solved using: SQL.
Count Palindromes in Range
Challenge No. 107: Palindrome numbers are those which are same even when read from backwards.
Solved using: Python in Excel.
Characters Repetition!
Challenge No. 105: In the question table, where some passwords are provided, extract the 6 most commonly used characters across all the passwords and count their repetitions.
Solved using:Excel (CONCAT, FILTER, GROUPBY), Google Sheets, Power Query (List.Combine, List.Distinct, List.Transform), Python, Python in Excel, and R.