Challenge No. 136: Mask the string with asterisks if a word given in Words column appears in that row.
Solved using: Power Query.
LOOKUP
Finds a value in a one-row or one-column range in Excel.
Get Last Order
Challenge No. 31: Get the last order for each Month
Dynamic array function allowed, but Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: Python.
Convert Strings to Morse
Challenge No. 125: Convert given strings into Morse codes.
Solved using: SQL.
Matching Tables!
Challenge No. 107: In a survey, 10 questions were asked to both
a manager and an expert, and they responded
to some of them.
Solved using:Excel (CHOOSECOLS, FILTER, HSTACK), Google Sheets, Power Query (List.PositionOf, List.Transform, Table.AddColumn), Python, Python in Excel, and R.
Replace with Past Vowels
Challenge No. 100: The string contains only English alphabets.
Solved using: SQL.
Approximate Lookup
Challenge No. 21: Lookup correct grades per subject
Marks below lowest grade is a fail
Dynamic array function allowed, but Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: Power Query.
Linear Interpolation!
Challenge No. 97: In the question table, the population data for cities A, B, and C are provided for different years.
Solved using:Excel, Google Sheets, Power Query, Python, Python in Excel, and R.
Last Inventory Level!
Challenge No. 95: In the Question table, monthly inventory levels of products are provided.
Solved using:Excel (BYROW, FILTER, HSTACK), Google Sheets, Power Query (List.RemoveNull, Table.AddColumn, Table.Group), Python, Python in Excel, and R.
Lookup and Get the Difference
Challenge No. 14: Rules:
Check Salary within Scale Table
If Exact within the table, (Salary-previous year Amount)
If between 2 years, get the difference between the two years
If No Previous Year, Return Zero
Strictly Legacy Array Functions or PowerQuery.
Solved using: Power Query.
Two-Column Text!
Challenge No. 94: In the question table, texts are provided for different groups.
Solved using:Excel (DROP, FILTER, HSTACK), Google Sheets, Power Query (List.Split, List.Transform, Table.ExpandTableColumn), Python, Python in Excel, and R.