Challenge No. 126: Combine Series 1 and Series 2 together and sort them and list those where elements of the combined series are in sequence with no gap.
Solved using: SQL.
TEXTSPLIT
Splits a text string into an array based on delimiters in Excel.
Generate Cartesian product of values
Challenge No. 34: Generate the Cartesian product as shown.
Solved using: SQL.
Reconciliation!
Challenge No. 110: After reconciling the company’s bank transactions with the records in the financial department, discrepancies were found between 5 rows of bank transactions and 7 rows of financial records.
Solved using: Excel.
Top Words in Presidents
Challenge No. 123: Column A contains list of US presidents.
Solved using: SQL.
Extract Top Number Groups
Challenge No. 114: Extract the group of numbers from A2:A11 and list the top 3 unique maximum and minimum numbers.
Solved using: SQL.
Find Non-Common Words
Challenge No. 112: Find the words which are not common between Group 1 and Group 2.
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.
Lookingup Common Data
Challenge No. 24: Put the applicants on either shortlist, longlist or disqualify them
Use the required technologies for long or shortlist
Dynamic array function allowed, but Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: Python in Excel.
Generate Italian Fiscal Code
Challenge No. 102: This is first part of 2 parts Italian Fiscal Code (Codice Fiscale) generation challenges.
Solved using: SQL.
Numbers with Odd Frequencies
Challenge No. 89: List the numbers which occur odd number of times.
Solved using: Python.