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

¥Î¨ç¼Æªí¥Ü

¥»©«³Ì«á¥Ñ ML089 ©ó 2016-3-26 17:42 ½s¿è

¦^´_ 1# kim223824

I2 ¬d¸ß¿é¤J 1112
H2 Åã¥Ü¸ê®Æ¦³¦h¤Öµ§¡A¤½¦¡ =COUNTIF(A:A,I2)

I3:M12 °Ï°ì°}¦C¤½¦¡
=INDEX(A:E,SMALL(IF(I2=A2:A11,ROW($2:$11),4^8),ROW(1:10)),{1,5,3,2,4})&""
¤½¦¡¤¤ ROW(1:10) ªí¥Ü¬°²Å¦X±ø¥óÁ`µ§¼Æ¡A¥i¥H¦Û¦æ½Õ¾ã»Ý¨D¡C

¥i¥H¥Î¤½¦¡¦WºÙ NO ³]©w°ÊºA½d³ò
=INDEX(A:E,SMALL(IF(I2=NO,ROW(NO),4^8),ROW(1:10)),{1,5,3,2,4})&""
¦WºÙ NO =OFFSET(!$A$2,,,COUNTA(!$A:$A)-1)
20160325_¬d¸ß1.rar (9.06 KB)

2016-03-26.png (90.4 KB)

2016-03-26.png

20160325_¬d¸ß.rar (9.06 KB)

20160325_¬d¸ß.rar (9.06 KB)

{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : §ïÅܦۤv¬O¦Û±Ï¡A¼vÅT§O¤H¬O±Ï¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD