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

¥Î¨ç¼Æªí¥Ü

¥Î¨ç¼Æªí¥Ü

¥»©«³Ì«á¥Ñ kim223824 ©ó 2016-3-25 20:35 ½s¿è

¦p¦ó¥Î¨ç¼Æ¥i¥H±N¥ªÃ䪺ªí®æÅܦ¨¥kÃä?
¦b¥kÃäªí®æNOÄæ¿é¤J " 1112" ´N·|±a¥X¨ä¥L6µ§¸ê®Æ
2016-03-25_202929.png

12324.rar (7.82 KB)

¦bµ{¦¡°Ï¨D¨ç¼Æ¡H¡H¡H
¸ê®Æ¦h¤£¦h¡A³oºØ¤½¦¡¤£Â÷ INDEX ,SMALL °}¦C¹Bºâ¡A
¸ê®Æ¤@¦h·|¥dÀÉ¡A¹ïÀÉ®×¾Þ§@¿é¤J¬Û·í¤£§Q¡A
¦ó¤£¿ý­Ó¿z¿ï¥¨¶°¡A­×¤@¤U´N¦n¡I¡I¡I
¡@
¡@

TOP

¥»©«³Ì«á¥Ñ 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

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

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

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

TOP

¥»©«³Ì«á¥Ñ ­ã´£³¡ªL ©ó 2016-3-26 16:21 ½s¿è

¢Õ¢°¡D¿é¤J¿z¿ï½s¸¹¡G1112
¢Ö¢±¡G¤U©Ô
=LOOKUP("z",IF({1,0},"",(MATCH(G$1,OFFSET(A$1,H1,,1999),)+H1)&""))
©Î
=LOOKUP("z",IF({1,0},"",(MATCH(G$1,OFFSET(A$1,H2,,COUNTA(A:A)-H2),)+H2)&""))

¢×¢±¡G¥k©Ô¤U©Ô
=IF($H2="","",INDEX($A:$E,$H2,CHOOSE(COLUMN(A$1),1,5,3,2,4)))

20160326-01.GIF
2016-3-26 16:18

TOP

¦^´_ 1# kim223824

¸Õ¸Õ¸ê®Æ¬d¸ß

   
play.gif
2016-3-27 00:00
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : °µ¦n¨Æ¤£¯à¤Ö§Ú¤@¤H¡A°µÃa¨Æ¤£¯à¦h§Ú¤@¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD