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.
SORT
Sorts an array in ascending or descending order in Excel.
Top Words in Presidents
Challenge No. 123: Column A contains list of US presidents.
Solved using: SQL.
List max frequency alphabets across
Challenge No. 33: Generate the answer as shown.
Solved using: SQL.
Sort by Type and Case
Challenge No. 116: Sort the strings within the cells.
Solved using: SQL.
Lookup Unique Set of Duplicates
Challenge No. 27: Extract Products with a Unique Set of 3 Customers in the whole dataset
For Example, Product A & D has a duplicate set of the 3 customers Dynamic array function allowed but Extra marks for Legacy solutions
or PowerQuery Solution.
Solved using: Python in Excel.
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.
Sort Planets and Data
Challenge No. 113: Sort the planets first and then sort the data in respective rows
Note – I have updated the file but picture will continue to show wrong data.
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.
Latest Date Shop Data
Challenge No. 106: Get the data for all shops corresponding to latest date as shown in the result table.
Solved using: Python in Excel.
Avg Cost Between City Pairs
Challenge No. 92: Find the average cost between the pair of cities.
Solved using: Python in Excel.