见图片
F2的公式为:
{=IF(ROW(A1)>COUNT(1/$C$2:$C$6),"",INDEX(A:A,SMALL(IF($C$2:$C$6>0,ROW($2:$6)),ROW(A1))))}
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b812c8fcc3cec3fd9d61f5fcd588d43f869427df?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
G2的公式为:
{=IF(ROW(B1)>COUNT(1/$C$2:$C$6),"",INDEX(C:C,SMALL(IF($C$2:$C$6>0,ROW($2:$6)),ROW(B1))))}
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/472309f790529822a7c26a4ad4ca7bcb0b46d442?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
关键点:
$C$2:$C$6是需要判断的单元格
INDEX后面的A:A或C:C是需要取值的列
其他的就没有啥了
注意公式需要输入完成后需要同时按Shift + Enter 不然是不行的。