Challenge No. 136: Mask the string with asterisks if a word given in Words column appears in that row.
Solved using: Power Query.
LAMBDA
Creates custom reusable functions in Excel.
Sum Negative Numbers Only
Challenge No. 135: Extract the negative numbers and sum them from the given strings.
Solved using: Python in Excel.
Add Suffix to Duplicates
Challenge No. 134: If an animal appears more than once, then that animal’s name should be suffixed with 1, 2, 3.
Solved using: SQL.
Duplicate Values! Part 2
Challenge No. 113: Consider the IDs in the question table.
Solved using:Excel (DROP, IF, LAMBDA), Google Sheets, Power Query (List.Transform, Table.AddColumn, Table.AddIndexColumn), Python, Python in Excel, and R.
Extract Complete Months
Challenge No. 32: Calculate the number of complete Months per Year per Project
For example, Proj A starts in 2022 (for 10 months), 2023(12 months), Ends 2024(6 months)
Dynamic array function allowed, but Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: R.
Match employee names using wildcard
Challenge No. 36: There are two tables.
Solved using: SQL.
Replace Masked Characters
Challenge No. 131: The strings given in column A have some alphabets which are masked i.
Solved using: Excel VBA.
Capitalize First and Last
Challenge No. 130: Convert the first and last letters of each word to upper case.
Solved using: Power Query (List.Transform).
Sort with Custom Rules
Challenge No. 129: We had a sorting challenge recently.
Solved using: Power Query.
Insert blank rows based on
Challenge No. 35: Insert the number of blank rows after the records as per Number column.
Solved using: Python.
