Challenge No. 197: List the qualifying player from each group on the basis of
1.
Solved using: Power Query (Table.AddColumn).
⭐️ Beginner
Easy challenges for newcomers.
Final Week Of The Month!
Challenge No. 134: From the “transactions” in the provided table, filter those that occurred in the last 7 days of the month.
Solved using:Excel (CHOOSECOLS, DAY, EOMONTH), Google Sheets, Power Query (Table.AddColumn, Table.SelectRows), Python, Python in Excel, R, and SQL.
Repeat Characters by Position
Challenge No. 196: Repeat a character as per its position in the string and insert spaces between them.
Solved using: Excel VBA.
Find Missing Letters in Order
Challenge No. 193: Listed are the strings where letters are in increasing order.
Solved using: Power Query.
Year Plus Digits Equals Current
Challenge No. 192: Excel formulas permit date range from 1-Jan-1900 to 31-Dec-9999.
Solved using: Python in Excel.
Find Max Sum Pairs
Challenge No. 190: Find the unique pairs of numbers whose sum is the maximum.
Solved using: Python in Excel.
Count Larger Numbers Below
Challenge No. 189: Populate the count of numbers larger than the number given in a cell.
Solved using: Python in Excel.
Sort Columns by Frequency
Challenge No. 188: Sort Col 1 through 5 column wise on the basis of frequency.
Solved using: Power Query (List.Transform).
Find Anagram Word Pairs
Challenge No. 187: An Anagram is a word which is made by rearranging the letters of another word.
Solved using: Power Query.
Compare Odd Even Counts
Challenge No. 186: If odd numbers are less, then post odd numbers.
Solved using: Power Query (List.Transform).