Challenge No. 336: Find the unique pair of numbers.
Solved using: Python in Excel.
MATCH
Returns the relative position of a value in an array in Excel.
Remove last occurrence of minimum number
Challenge No. 328: — Looks like scheduling didn’t work today and challenge didn’t get posted—
Remove the last minimum number from given strings.
Solved using: Python in Excel.
Find missing terms in arithmetic progressions
Challenge No. 325: Find the missing terms in Arithmetic Progressions given.
Solved using: Python in Excel.
List subjects appearing within +/-1 row in column B
Challenge No. 324: List the subjects from column A which appear in column B within +1 or -1 position to column A.
Solved using: DAX.
Top 3 employees nearest to average salary
Challenge No. 322: Find the top 3 employees whose salary is nearest to average salary.
Solved using: DAX.
Sort the digits of given numbers in descending order
Challenge No. 311: Sort the digits of given numbers in column A in descending order.
Solved using: Python in Excel.
Split words by half total alphabet score
Challenge No. 299: Consider a=1..
Solved using: Python in Excel.
Teams With No Losses
Challenge No. 280: List the Teams which have never lost even a single game.
Solved using: Python in Excel.
Custom Grouping! Part 14
Challenge No. 168: The stock prices for the given dates are provided in the question table.
Solved using:Excel (IF, LAMBDA, LET), Google Sheets, Power Query (Table.Group, Table.AddIndexColumn, Table.ExpandTableColumn), Python, Python in Excel, and R.
Find Previous Prime Digit Number
Challenge No. 261: Single digit prime numbers are 2, 3, 5 & 7.
Solved using: Excel VBA.