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

[µo°Ý] ·Q¨ú¥X¦P¶µ¥Ø°µ¦X¨Ö

[µo°Ý] ·Q¨ú¥X¦P¶µ¥Ø°µ¦X¨Ö

Dear :

ÃD¥Ø¬O³o¼Ë¡A§Ú¦³¼Æ­Ótable¡A¦ý¬O§Æ±æ§âtableªºµ²ªG¦X¨Ö(¨ú¥X¦P¼Ë¶µ¥Ø)¡A¬O§_¦³¤½¦¡©Î¨ä¥¦¤è¦¡¥i¥H¨ú¥X¨Ó©O¡H(³o¦¸¦³ª¾¹D¥i¥HªþÀÉ)¡A°Ñ¦Òªþ¥ó¡A¦A¦¸ÁÂÁ¤j®a

example.rar (3.56 KB)

¦^´_ 1# jj369963

ªí®æ¤£³s³e­nª½±µ½Æ»s¤½¦¡·|¦³§xÃø
¥Î®æ¦¡¤Æ±ø¥óÅã¥Ü¤À²Õ¡]¦p¹Ï¡^


example.rar (12.15 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# Hsieh


    ¤£¦n·N«ä¡A§Ú¤ñ¸û²Â¡A¥Bµ¥¯Å¤£°÷µLªk¤U¸ü¡A¦ü¥G°µ¥X¨Óªºµ²ªG¤£¤@¼Ë¡C®M¥Î¤½¦¡µ²ªG¦pªþÀÉ¡A

¨t©Ò³]©w
±Ð®v³]©w_­ì©l¤À¼Æ
±Ð®v³]©w_­Ó¤H¤º¼Ð·Ç¤À¼Æ
±Ð®v³]©w_±Ð®v¶¡¼Ð·Ç¤À¼Æ
¾Ç¥Í³]©w

¦³¶¶§Q¨ú¥X¡A¦ý¬O¼Æ­È«oµLªk¡A¬O§_¥i¥H¦b½Ð±Ð©O¡H
¦A³Â·Ð¡AÁÂÁÂ

example0401.rar (3.89 KB)

TOP

¦^´_ 3# jj369963

Hsieh¶Wª©¤§µª®×

¦p¹Ï
1.´¡¤JA,B¨âÄæªÅ¥ÕÄæ
2.A38=INDIRECT("C"&MIN(IF(ISERROR(MATCH($C$1:$C$30,$A$37:A37,0)),ROW($C$1:$C$30),"")))
  °}¦C¤½¦¡(¤½¦¡¿é¤J¦n¶·«öCtrl+Shift+Enter²Õ¦XÁä)
  ©¹¤U½Æ»s¨ìA43
  B39=SUM(COUNTIF($C$1:$C$30,$A$39:A39))
  °}¦C¤½¦¡(¤½¦¡¿é¤J¦n¶·«öCtrl+Shift+Enter²Õ¦XÁä)
  ©¹¤U½Æ»s¨ìB43
  C38=IF(ROW(A1)>MAX($B$39:$B$43),"",LOOKUP(ROW(A1),$B$39:$B$43-$B$39+1,$A$39:$A$43))
  °}¦C¤½¦¡(¤½¦¡¿é¤J¦n¶·«öCtrl+Shift+Enter²Õ¦XÁä)
  ©¹¤U½Æ»s
  D38=IF($C38="","",INDIRECT("R"&SMALL(IF($C$1:$C$30=$C38,ROW($C$1:$C$30),""),COUNTIF($C$38:$C38,$C38))&"C",0)&"")
  °}¦C¤½¦¡(¤½¦¡¿é¤J¦n¶·«öCtrl+Shift+Enter²Õ¦XÁä)
  ©¹¤U½Æ»s,©¹¥k½Æ»s

TOP

        ÀR«ä¦Û¦b : ª¾ÃÑ­n¥Î¤ßÅé·|¡A¤~¯àÅܦ¨¦Û¤vªº´¼¼z¡C
ªð¦^¦Cªí ¤W¤@¥DÃD