Challenge No. 153: Convert the given positive numbers to Binary numbers.
Solved using: Python in Excel.
⭐️⭐️ Easy
Slightly challenging problems for learners.
Condition Formatting
Challenge No. 39: Condition Format Project days Excluding Weekend
e.
Solved using: R.
Check Narcissistic Numbers
Challenge No. 147: A Narcissistic number is that number which is the sum of nth powers of its digits where n is the length of the number.
Solved using: Python in Excel.
Right Strip Given Chars
Challenge No. 145: Remove RSTRIP Chars from Input String from right side.
Solved using: SQL.
Add Index Column! Part 2
Challenge No. 116: Add an index column to the question table, with a separate counter for each stock.
Solved using:Excel (CHOOSECOLS, CHOOSEROWS, COLUMN), Google Sheets, Power Query (List.Alternate, Table.AlternateRows, Table.Column), Python, Python in Excel, and R.
Multi Replacement!
Challenge No. 115:
Replace “q” and “000” in the Product ID and Customer ID columns with “-“.
Solved using:Excel (HSTACK, LAMBDA, LET), Google Sheets, Power Query (Text.Replace, Table.ReplaceValue, Table.TransformColumns), Python, Python in Excel, R, SQL, and VBA.
Vowel End and Start Words
Challenge No. 139: List those sentences which contain any pair of words where first word ends with vowel and next word starts with vowel.
Solved using: Power Query.
Sort with Custom Rules
Challenge No. 129: We had a sorting challenge recently.
Solved using: Power Query.
Left Strip Given Chars
Challenge No. 127: Remove LSTRIP Chars from Input String from left side.
Solved using: Python in Excel.
Check Sequential Series
Challenge No. 126: Combine Series 1 and Series 2 together and sort them and list those where elements of the combined series are in sequence with no gap.
Solved using: SQL.