Challenge No. 405: Sandwich numbers – A number is said to be a Sandwich number if the number prior to it and the number after it, both are primes.
Solved using: Excel VBA.
IF
Returns one value for TRUE and another for FALSE based on a condition in Excel.
Render ASCII US Flag
Challenge No. 404: Generate US ASCII flag.
Solved using: Python.
Department Totals and Summary
Challenge No. 165: Insert the total row containing count of employees and sum of salary at the bottom of each dept groups.
Solved using: R.
Encrypt Using Vigenere Cipher
Challenge No. 402: Vignere Cipher – Write the plain text (p) and keyword (k) beneath that.
Solved using: Python in Excel.
Form Pyramid from Text String
Challenge No. 401: Prepare the triangle from column A strings.
Solved using: Python.
Check Connectivity of Random Points
Challenge No. 400: Coordinates for points are given in x, y format.
Solved using: R.
Validate Point Connectivity Rule
Challenge No. 395: Coordinates for points are given in x, y format.
Solved using: DAX.
Generate Axis for Four Quadrants
Challenge No. 389: Generate X and Y axes of all 4 quadrants for value given in A1.
Solved using: R.
Last Weekday of Each Month
Challenge No. 387: For a date given in cell A1, generate the last Mon through Sun of the month
-1 : Last
-2 : 2nd Last.
Solved using: Python.
Extract Numbers Inside Parentheses
Challenge No. 386: Extract the numbers from the string if ONLY numbers are contained within the parentheses.
Solved using: Python in Excel.