Challenge No. 35: Insert the number of blank rows after the records as per Number column.
Solved using: Python.
LAMBDA
Creates custom reusable functions in Excel.
Compare Rows! Part 2
Challenge No. 111: In the historical sales table, extract the dates where the total sales value is greater than the total on the previous date
for example, in 2/1/2024 total sales were 14 and is greater than total sales on 1/1/2024 which is 11.
Solved using:Excel (DROP, FILTER, IF), Google Sheets, Power Query (Table.Group, Table.SelectRows), Python, Python in Excel, and R.
Left Strip Given Chars
Challenge No. 127: Remove LSTRIP Chars from Input String from left side.
Solved using: Python in Excel.
Check Sequential Series
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.
Convert Strings to Morse
Challenge No. 125: Convert given strings into Morse codes.
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.
Find Disarium Numbers
Challenge No. 124: List the Disarium numbers from column A.
Solved using: Python in Excel.
Top Words in Presidents
Challenge No. 123: Column A contains list of US presidents.
Solved using: SQL.
Lookup Uncommon Names in the set
Challenge No. 29: Extract Staff who only attended 1 training
Dynamic array function allowed, but Extra
marks for Legacy solutions or PowerQuery Solution.
Solved using: Python in Excel.
Add Large Text Numbers
Challenge No. 122: Add Number1 and Number 2 together.
Solved using: Python in Excel.