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

[µo°Ý] ·j´M§Ç¸¹¨Ã±a¥X»s¥O¸¹½X

[µo°Ý] ·j´M§Ç¸¹¨Ã±a¥X»s¥O¸¹½X

ÁٽЦU¦ì¤j¤jÀ°¦£
¦]¬°½s½X­ì«h°ÝÃD¡A·j´M¤è¦¡ µLªk¹³¤§«e¥u¬O³æ¯Â¸¹½X¥i¥H¨Ì°Ï¶¡ §ä¥X¸¹½X
·Q§Q¥Î¨ç¼Æ ¿é¤J¤@§Ç¸¹¸¹¤§«á ¯à±a¥X»s¥O¸¹½X
­ì¥»·Q¥Î¥¨¶°¥h¼g ¦ýê©ó½s½X­ì«h°ÝÃD ¥ý¨Ï¥Î¨ç¼Æ·j´M
¦p¤U §Ú¿é¤J¤@¸¹½X ¦b»s¥O¬d¸ßªº¤À­¶ ­n¯à¦b§Ç¸¹Á`ªí¤º§ä¨ìµª®×  µª®×§Ú¤w¸g¥ÎÃC¦â°Ï¤À
¦Ó¿é¤Jªº§Ç¸¹ ¤]¤w¸g¦b»s¥O¬d¸ßªº¤À­¶¥ý¿é¤J¦n¤F
ªþ¤WÀÉ®× !!¤º®e¦³¼g¥X½s½X­ì«h!!ÁٽЦU¦ì°ª¤âÀ°¦£¨ó§U ÁÂÁÂ

§Ç¸¹¬d¸ß.zip (67.7 KB)

¦^´_ 1# fantersy

¬O¥Î"°_©lBarcode"·j´M"¤u³æ¸¹½X"¶Ü??
D2=VLOOKUP(D1,IF({1,0},§Ç¸¹Á`ªí!K:K,§Ç¸¹Á`ªí!B:B),2,0)

TOP

¥»©«³Ì«á¥Ñ fantersy ©ó 2020-6-13 12:00 ½s¿è

¦^´_ 2# jcchiang

¤j¤j±z¦n
¤£¬O¥Î°_©l§Ç¸¹ ¥h·j´M
¦Ó¬O­n ¿é¤J§Ç¸¹¤§«á
¯à¦Û¤v§ä¨ì°Ï¶¡
¨Ã¹ïÀ³¨ì¬Û¹ï¤u³æ¸¹½X
±zªº¤è¦¡ ¬O¨Ï¥Î°_©l ©ÎªÌµ²§ôªº§Ç¸¹ ¥h§ä
¤À­¶ »s¥O¬d¸ß  §Ú¹w³]¤F¤@­Ó¸¹½X  ­n¯à§ä¨ì¬õ¦âªºµª®×
  ÁÂÁ±zªº¨ó§U

TOP

¦^´_ 3# fantersy


¬Ý¤£À´½s½X«ç»ò­pºâ??
¥u­n«eºó«áºó³£¬Û¦P, À³¥iª½±µ¤ñ¤j¤p§a~~
=iferror(LOOKUP(1,0/(D1>=§Ç¸¹Á`ªí!K1:K603)/(D1<=§Ç¸¹Á`ªí!M1:M603),§Ç¸¹Á`ªí!B:B),"§ä¤£¨ì")

TOP

¦^´_ 4# ­ã´£³¡ªL

²a¯« ªGµM¼F®`
¤p§Ì¸Õ¤F¦n´Xµ§ µª®×³£¹ï
½s½X¬O¤ñ¸û¯S®íªº¤è¦¡
¦ý¨S·Q¨ì ¥ÎLOOKUP ´N¥i¥H¸Ñ¤F
ÁÂÁ¤j¯«ªº¨ó§U
·P®¦

TOP

        ÀR«ä¦Û¦b : ¨Ã«D¦³¿ú¾{¬O§Ö¼Ö¡A°Ý¤ßµL·\¤ß³Ì¦w¡C
ªð¦^¦Cªí ¤W¤@¥DÃD