你可以试试-

=CHOOSE({1,2},UNIQUE(A2:A19),BYROW(UNIQUE(A2:A19),LAMBDA(x,INDEX(SORT(FILTER(B2:C19,A2:A19=x),2,-1),1,1))))

带有页眉-

=LET(a,UNIQUE(A2:A19),b,BYROW(a,LAMBDA(x,INDEX(SORT(FILTER(B2:C19,A2:A19=x),2,-1),1,1))),VSTACK({"Dist","Candidate"},HSTACK(a,b)))

您可以在单元格E2中尝试以下操作：

=LET(rng, A2:C19, dists, INDEX(rng,,1), names, INDEX(rng,,2), 
  pcts, INDEX(rng,,3),
  distsUx, UNIQUE(dists),
  result, MAP(distsUx, LAMBDA(dist,
    TEXTJOIN(",",,FILTER(names, (dists=dist) 
    * (pcts = MAX(FILTER(pcts, dists=dist)))))
  )),
  HSTACK(distsUx, result)
)

输出如下：

注：如果同一地区内有多个名称具有相同的max pct，则返回以逗号分隔的名称。