C1:=A1
C2:
=IF(ROW(C2)>SUM(B:B),"",IF(COUNTIF($C$1:C1,C1)
在c1输入牛,c2输入公式=if(row(a2)>sum(b:b),"",if(row()-match(c1,c$1:c1,0)