你的单项奖放在哪个单元格区域？假设参加人员为COUNT(C:C)，那么C列的单项奖名次分别为=LOOKUP(RANK(C2,C:C),COUNT(C:C)*{0,0.2,0.5,0.9},{"一等奖","二等奖","三等奖","优秀奖"})
