Challenge No. 201: Find the next number which is having all digits distinct.
Solved using: Python in Excel.
LAMBDA
Creates custom reusable functions in Excel.
List Isogram Words Only
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.
List Question Options Summary
Challenge No. 59: Generate the result table where –
Questions should be listed in headers.
Solved using: Power Query (List.Transform, Table.SelectRows).
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.
Sum-Month Equals Year Dates
Challenge No. 199: List the count of dates along with Min and Max date for the rows in columns A & B where MM + DD = YY.
Solved using: Python in Excel.
Detect Operators Between Numbers
Challenge No. 198: List the operator which operates between Number 1 and Number 2.
Solved using: Python in Excel.
Compute Daily Opening Balance
Challenge No. 58: Starting opening balance (OB) = 100 (This is given and you will need to work out OB for Serials 2 through 9)
Hence, Serial no.
Solved using: SQL.
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.