Challenge No. 128: Write all the 3 character words by using “A”,”B”,C”, AND “D”.
Solved using:Excel (LAMBDA, LET, REDUCE), Google Sheets, Power Query (List.Transform, List.TransformMany), Python, Python in Excel, and R.
SORT
Sorts an array in ascending or descending order in Excel.
Common Digits with Frequency
Challenge No. 177: Find the common digits between Number1 and Number2 if the occurrence frequency of a digit is same in both Number1 and Number2 and occurrence frequency of that digit > 1.
Solved using: Power Query (List.Transform).
Add Index Column! Part 4
Challenge No. 127: Add an index column to the question table, with a separate counter for each stock.
Solved using:Excel (DROP, FILTER, HSTACK), Google Sheets, Power Query (Table.AddColumn, Table.AddIndexColumn), Python, Python in Excel, and R.
Common Words Between Sentences
Challenge No. 175: Find the common words between Sentence1 and Sentence 2 and sort the common words.
Solved using: Power Query (Text.Split).
Table Transformation! Part 11
Challenge No. 122: Transform the question table into the reult table format.
Solved using:Excel (DROP, FILTER, HSTACK), Google Sheets, Power Query (List.Transform, Text.Contains, Table.AddColumn), Python, Python in Excel, and R.
Top Duration Players
Challenge No. 158: List the top 3 players in decreasing order of duration.
Solved using: Python in Excel.
Dso!
Challenge No. 118: Using the sales transactions from the provided table and the account balance as of 31/08/2024, calculate the Daily Sales Outstanding (DSO) for each customer.
Solved using:Excel, Google Sheets, Power Query, Python, Python in Excel, and R.
Common Letters Sorted
Challenge No. 140: List the common letters between Word1 and Word2 and sort them alphabetically.
Solved using: Power Query (List.Distinct, Table.AddColumn).
Top Initial Letters Count
Challenge No. 138: Find the top 5 highest occurring starting alphabets of words in US Presidents columns.
Solved using: Python in Excel.
Top Rank Improvements
Challenge No. 132: List the Top 3 players whose rank improved the most from 2021 to 2022.
Solved using: Python in Excel.