Challenge No. 112: Find the words which are not common between Group 1 and Group 2.
Solved using: SQL.
LAMBDA
Creates custom reusable functions in Excel.
Sum Word Lengths in Range
Challenge No. 111: Generate all the numbers between From and To.
Solved using: SQL.
Generate Concatenation Table
Challenge No. 110: Generate the result table.
Solved using: SQL.
Format FIFA data with hyphens
Challenge No. 30: — This week is for FIFA world cup challenges —
Insert a hyphen ( i.
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.
Find max finals gap for
Challenge No. 29: — This week is FIFA world cup challenges —
If a country has appeared more than once in finals, find the maximum gap in years for next – previous appearance for that country.
Solved using: SQL.
Weekday Count of Christmas
Challenge No. 105: Find the counts of weekday names of Christmas during last n years mentioned in A1.
Solved using: SQL.
Generate Fibonacci Strings
Challenge No. 104: Generate n Fibonacci strings for given first two terms.
Solved using: SQL.