ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

¦p¦ó¹ïÀH¾÷±Æ¦C¤§¤å¦r«¬¼Æ¦r¶i¦æ±Æ§Ç¡H

B2
=IF(A2="","",SUMPRODUCT((--A2>--A$2:A$11)*(A$2:A$11<>""))+1+COUNTIF(A$1:A1,A2))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ºw¤ô¦¨ªe¡C²É¦Ì¦¨ÅÚ¡A¤Å»´¤vÆF¡A¤Å¥Hµ½¤p¦Ó¤£¬°¡C
ªð¦^¦Cªí ¤W¤@¥DÃD