Challenge No. 691: Give the rank1 and rank2 as shown.
Solved using: Python.
XMATCH
Returns the relative position of a value in an array with advanced options in Excel.
Pick top N by group
Challenge No. 271: From first group, pick up top 1 on the basis of revenue, from second group, pick up top 2 and so on.
Solved using: Python in Excel.
Rank stores by percentage of
Challenge No. 263: Table 1 (T1) has got customer satisfaction responses and Table 2 (T2) has got color coding of those responses.
Solved using: Python.
Rank Players by Uppercase
Challenge No. 545: There are 6 players (q, w, e, r, t, y) and if a player wins, it appears in upper case and if it loses, then it appears in lower case.
Solved using: Python.
Rank Sales Drop Per Person
Challenge No. 239: Transpose the problem table into result table and calculate the drop in sales amount from one quarter to previous quarter.
Solved using: Python.
Rank by Student Grade
Challenge No. 518: Rank the students on the basis of grades.
Solved using: Python.
Aggregate Customer Purchase Stats
Challenge No. 503: Today’s challenge is contributed by 🇰🇷 Taeyong Shin
Calculate the sum, average, maximum value, minimum value, count, and payment amount for products purchased by each customer.
Solved using: Python in Excel.
Sort Rows by Reference Column
Challenge No. 468: This challenge was posed by Sunny Baggu
List the rows from problem table as per column H.
Solved using: Python in Excel.
Rank Sales with Tie Handling
Challenge No. 450: Assign rank on the basis of sales made by different salespersons in a company.
Solved using: Excel VBA.
Interpolate Grid Position Values
Challenge No. 440: Today’s challenge is proposed by Sunny Baggu
a is for row 1 and b is for column 1.
Solved using: Python in Excel.