Challenge No. 155: Polybius cipher
Encrypt the text in column I as per grid in A2:G8.
Solved using: Python in Excel.
TOCOL
Converts a range or array into a single column in Excel.
Grid Sum Generation
Challenge No. 142: Generate the result grid which is the sum of input grid.
Solved using: Python in Excel.
Merge! Part 1
Challenge No. 114: In Question Table 1, the dates and product IDs are provided.
Solved using:Excel (FILTER, HSTACK, IFERROR), Google Sheets, Power Query (Text.Split, Table.AddColumn), Python, Python in Excel, R, and SQL.
Get Dates Before and After a New Order
Challenge No. 33: Get the dates BEFORE and AFTER a NEW ORDER
Dynamic array function allowed but Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: Python 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.
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.
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.
List max frequency alphabets across
Challenge No. 33: Generate the answer as shown.
Solved using: SQL.
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 Two Numbers with Sum
Challenge No. 98: From column A, find 2 numbers which when summed give the sum as in column C.
Solved using: Python.