Challenge No. 121: Calculate Digital root of the given numbers.
Solved using: Python in Excel.
MAP
Applies a function to each element of one or more arrays in Excel.
Trim Underscores at Ends
Challenge No. 119: Remove the trailing and leading underscore characters.
Solved using: SQL.
Avg Cooperation Time!
Challenge No. 108: Calculate the average cooperation time in months for those who are still with the company (do not have value on column leave date) as of 16/08/2024, categorized by their respective levels.
Solved using:Excel (AVERAGE, FILTER, HSTACK), Google Sheets, Power Query (Date.Month, Date.Year), Python, Python in Excel, and R.
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.
Generate Fibonacci Strings
Challenge No. 104: Generate n Fibonacci strings for given first two terms.
Solved using: SQL.