Challenge No. 439: Today’s challenge is proposed by Sunny Baggu
a is for row 1 and b is for column 1.
Solved using: Python in Excel.
XMATCH
Returns the relative position of a value in an array with advanced options in Excel.
Decode Color Band Resistance
Challenge No. 420: For the given color bands in Column E, work out the total resistance.
Solved using: Python 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.
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.
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.
Sorted Vowel Substitution
Challenge No. 239: Replace the vowels with vowels in sorted order.
Solved using: Excel VBA.
Find Missing Letters in Order
Challenge No. 193: Listed are the strings where letters are in increasing order.
Solved using: Power Query.
Fill Arithmetic Progression
Challenge No. 182: Find the missing numbers in Arithmetic Progressions given.
Solved using: Python in Excel.
Max Items Within Budget
Challenge No. 180: Provide a formula to list the maximum number of items (one unit only of each item) which can be bought in $150 from A2:A10.
Solved using: Power Query (Table.Sort).
Merge! Part 2
Challenge No. 124: In Question Table 1, dates and prices for a product are provided.
Solved using:Excel (INDEX, LAMBDA, LET), Google Sheets, Power Query (Table.AddColumn), Python, Python in Excel, and R.