Challenge No. 303: Remove the digits in each position and list those numbers which are prime for all occurrences of removal.
Solved using: Python in Excel.
MAP
Applies a function to each element of one or more arrays in Excel.
List the Polydivisible numbers
Challenge No. 301: List the Polydivisible numbers.
Solved using: Python in Excel.
Split words by half total alphabet score
Challenge No. 299: Consider a=1..
Solved using: Python in Excel.
Max Call Duration Pair
Challenge No. 298: Work our the pair of persons for whom the sum of call duration is the highest.
Solved using: Python in Excel.
Evaluate Reverse Polish Notation
Challenge No. 297: Simplified version of Reverse Polish Notation (RPN) – The math operator will come at the end of the Text and you need to evaluate the expression.
Solved using: Python in Excel.
Find Palindromic Numbers via 196
Challenge No. 296: 196-Algorithm – Take any positive integer of two digits or more, reverse the digits, and add to the original number.
Solved using: Python in Excel.
Lookup Date When Target was Hit
Challenge No. 49: Lookup the date when the staff total sales hit or exceeded the target
Current target is 800, but needs to be dynamic
e.
Solved using: Python.
Words in Alphabetical Order
Challenge No. 293: Provide a formula to list all words from A2:A10 where English alphabets appear in alphabetical order.
Solved using: Python in Excel.
Filter!
Challenge No. 174: In the question table, filter out rows where there is a greater value within the two days before or after the current row.
Solved using:Excel (AND, FILTER, IF), Google Sheets, Power Query (Table.SelectRows), Python, Python in Excel, and R.
Matches With Equal Goal Difference
Challenge No. 290: List the matches where goal difference is same.
Solved using: Python in Excel.