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

·Q°¸¼Æ¤é¸ò©_¼Æ¤é¿ï¾Ü¤£¤@¼Ëªº¸ê°T

·Q°¸¼Æ¤é¸ò©_¼Æ¤é¿ï¾Ü¤£¤@¼Ëªº¸ê°T

¦U¦ì«e½ú,
      §Ú·Q¦bexeclªí,°¸¼Æ¤é¸ò©_¼Æ¤é±a¤£¤@¼Ëªº¸ê°T
¬O§_¦³¨ç¼Æ¥i¥HÀ°¦£ ¦Û°Ê.rar (5.34 KB)

  1. B11 =IF(MOD(DAY(NOW()),2),"¥D­n²£«~","²£·~¦a¦ì")
  2. B12 =IF(COUNTIF(INDIRECT(B$11&"!A:A"),A12),VLOOKUP(A12,INDIRECT(B$11&"!A:C"),3,))
½Æ»s¥N½X
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 2# ML089

·PÁ§AªºÀ°¦£,¤w¸g¥i¥H¨Ï¥Î¤F
ÁÙ¦³­Ó°ÝÃD,¥i§_¦Û¦æ¿ï¾Ü
·Q±a¥X¨º­Ó¸ê°T,¦pªþ¥ó
¦Û°Ê.rar (5.29 KB)

TOP

¦^´_ 3# yan2463


    ¥i¥H±Ä¥Î¿ï³æ¤è¦¡¤ñ¸ûª½±µ

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

TOP

¦^´_ 4# ML089
¯uªºÁÂÁÂ,¤v¸g³]©w¦n¤F
¥i¥H¨Ï¥Î

TOP

¦^´_ 5# yan2463
¦Û°Ê.rar (5.15 KB)
¦]¬°³Ìªñ¦³¨Ç­ÓªÑ·j´M¤£¨ì¸ê°T,¥X²{¿ù»~°T®§
­Y·j´M¤£¨ì¬O§_¥i¥H±a¥X¥t¤@­Ó¸ê°T,©Î¬OÅã¥ÜªÅ¥Õ

TOP

¦^´_ 6# yan2463

B12 =IF(COUNTIF(INDIRECT(B$11&"!A:A"),A12),VLOOKUP(A12,INDIRECT(B$11&"!A:C"),3,),"")

«á­±¥[ "" ´N¬O§ä¤£¨ìÅã¥Ü ""
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 7# ML089
ÁÂÁÂ,¤v¸g³]©w§¹¦¨

TOP

        ÀR«ä¦Û¦b : ¬°¤H³B¥@­n¤p¤ß²Ó¤ß¡A¦ý¤£­n¡u¤p¤ß²´¡v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD