=IF(COUNTIFS(C:C，C3，B:B，" & gt= " & ampB3)& lt； COUNTIF(C:C, C3)*0.2, "high", "")
Where countifs (c: c, C3, b: b, ">; = "& ampB3) indicates that the number of people in the team is greater than their own, and the result is ranking. COUNTIF(C:C, C3) indicates the total number of people in the team, and the top 20% of IF judgment is high, as shown in the following figure:
After 20% similarity is achieved, judge by the number of people lower than yourself, and finally nest to get the final formula:
=IF(COUNTIFS(C:C，C3，B:B，" & gt= " & ampB3)& lt； COUNTIF(C:C, C3)*0.2, "high"
IF(COUNTIFS(C:C，C3，B:B，" & lt= " & ampB3)& lt； COUNTIF(C:C, C3)*0.2, "low"
"Medium"))
As shown in the figure below: