|
<p>A2公式:=IF(COUNT(B2)=1,IF(LOOKUP(1,0/($A$1:A1<>""),$A$1:A1)=$A$1,1,LOOKUP(1,0/($A$1:A1<>""),$A$1:A1)+1),"")</p><p>D2公式:=IF(COUNTIF(E2,"*")=1,IF(LOOKUP(1,0/($D$1:D1<>""),$D$1:D1)=$D$1,1,LOOKUP(1,0/($D$1:D1<>""),$D$1:D1)+1),"")</p><p><br/></p> |
|