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

[µo°Ý] µ{¦¡°ÝÃD½Ð±Ð¦U¦ì¥ý¶i

[µo°Ý] µ{¦¡°ÝÃD½Ð±Ð¦U¦ì¥ý¶i

¦b¥[Á`²Î­pªí¤¤²£¥Í#N/A,¦p¦ó¥h§JªA
·Ð½Ð¦U¦ì¥ý¶i«ü¾É

¥[¯Z.rar (11.32 KB)

¦^´_ 1# aaaaa388


    VLOOKUP(B21,Á`ªí!$L$14:$N$17,3,FALSE
°²³]¥H¤W¤½¦¡¬O A
=IF(ISNA( A  ) , 0 , A )
´N¥~­±¦A¥]¤@¼h IF ISNA´N¹ï¤F@@"
¦Û¥Î¨®¤]¥i¥Hñ±b³á!
¤­¤d¤¸¥[ªoª÷¥[¤Jªo½c«áÁÙ¦^õX±z6200¤¸
ºÖ§Q©ô¨®¤Í·|power-want.com

TOP

³o¦ì¤j¤j¡A±zvlookupªº³]©w®Ú¥»¨S¦³¹ïÀ³¨ì¸ê®Æ¡A©Ò¥H±zªº"¥[¯Z²Î­pªí®æ"¶È¦³©Ò¹ïÀ³¨ìªº©m¤ó¸ê®Æ¤~¦³­È¡A±NÁ`ªí¥[¤J¸ê®Æ´N¥i¸Ñ¨M¦¹°ÝÃD~

TOP

©êºp §Ú¨Sª`·N§A­nªº¬O­n§ä­È  ¦Ó¤£¬O§âna¥h±¼= ="!.....
¦Û¥Î¨®¤]¥i¥Hñ±b³á!
¤­¤d¤¸¥[ªoª÷¥[¤Jªo½c«áÁÙ¦^õX±z6200¤¸
ºÖ§Q©ô¨®¤Í·|power-want.com

TOP

:P ¦^´_ 4# die78325

sorry¨S¦³¼g²M·¡,§Ú­nªºµ²ªG¦p¦P²Ä¤G¼h¤j¤j
¤£¹LÁÙ¬O·PÁ²ĤT¼h¤j¤j
ÁÂÁ¦U¥ý¶i«ü±Ð

TOP

¦^´_ 5# aaaaa388

¥Îcountif()¹LÂo¬O§_¬d±o¨ì­È
    d7=IF(COUNTIF(Á`ªí!$D$25:$H$30,B7),VLOOKUP(B7,Á`ªí!$D$25:$H$30,5,FALSE),"")
    ¥H¤U¤½¦¡¥i¦V¥k¤Î¤Ucopy
    d7=IF(COUNTIF(OFFSET(Á`ªí!$D$25:$H$30,(COLUMN(A1)-1)*9,),$B7),VLOOKUP($B7,OFFSET(Á`ªí!$D$25:$H$30,(COLUMN(A1)-1)*9,),5,FALSE),"")

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡µLªk¾B¾×¡j©È®É¶¡®ø³u¡Aªá¤F³\¦h¤ß¦å¡A·QºÉ¦U¦¡¤èªk­n¾B¾×®É¶¡¡Aµ²ªG¬O¡G®ö¶O¤F§ó¦h®É¶¡¡A¥B¤@µL©Ò¦¨¡I
ªð¦^¦Cªí ¤W¤@¥DÃD