Excel表a1为牛,B1为5,那么C1至C5为牛,然后A2为马,B2为3那么C列从空白单元格也就

2025-05-11 13:41:09
推荐回答(2个)
回答1:

C1:=A1

C2:

=IF(ROW(C2)>SUM(B:B),"",IF(COUNTIF($C$1:C1,C1)

回答2:

在c1输入牛,c2输入公式=if(row(a2)>sum(b:b),"",if(row()-match(c1,c$1:c1,0)