Challenge No. 200: List all isograms from column A – An isogram is that word where letters occur same number of times
Ex.
Solved using: Power Query.
MAP
Applies a function to each element of one or more arrays in Excel.
Identify The Pattern !
Challenge No. 135: Find the number of occurrences of the “+-+” pattern across the test IDs for each product.
Solved using:Excel (BYROW, CONCAT, DROP), Google Sheets, Power Query (List.Range, Text.Combine, Table.AddColumn), Python, Python in Excel, and R.
Detect Operators Between Numbers
Challenge No. 198: List the operator which operates between Number 1 and Number 2.
Solved using: Python in Excel.
Top Player by Group Average
Challenge No. 197: List the qualifying player from each group on the basis of
1.
Solved using: Power Query (Table.AddColumn).
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.
Trim Characters Before Asterisk
Challenge No. 194: Remove the characters preceding the asterisks.
Solved using: Power Query.
Find Missing Letters in Order
Challenge No. 193: Listed are the strings where letters are in increasing order.
Solved using: Power Query.
Merge! Part 3
Challenge No. 132: In Question Table 1, values are provided for each code.
Solved using:Excel (FILTER, FIND, ISNUMBER), Google Sheets, Power Query (Text.Contains, Table.AddColumn, Table.SelectRows), Python, Python in Excel, R, and VBA.
Find Max Sum Pairs
Challenge No. 190: Find the unique pairs of numbers whose sum is the maximum.
Solved using: Python in Excel.