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

[µo°Ý] ®æ¦¡¤Æ±ø¥ó¤½¦¡°ÝÃD

[µo°Ý] ®æ¦¡¤Æ±ø¥ó¤½¦¡°ÝÃD

¨D±Ð
¦p¤u§@ªí ¡§sale¡¨ AÄ椺Àx¦s®æ­È »P ¤u§@ªí ¡§stock¡¨ BÄ椺¦³¬Û¦P­È, «h¡§sale¡¨ AÄ椺Àx¦s®æ­È¥H¬õ¦âÅã¥Ü
§Æ±æ®ÄªG¦p¤U, ®æ¦¡¤Æ±ø¥ó¤½¦¡­n¦p¦ó³]©w?
tem.JPG furniture.rar (6.33 KB)
§V¤O¾Ç²ß¤¤,ÁÂÁ«e½ú

®æ¦¡½d³ò¬° $A$2: $A$5000
  1. =COUNTIF(stock!$B:$B,$A2)>0
½Æ»s¥N½X

TOP

¦^´_ 1# hkyan

§Ú¬O¥Î2007ª©¥»

®æ¦¡¤Æ±ø¥ó¨S¿ìªk¸ó¤u§@ªí

©Ò¥H§Ú¦b¦WºÙºÞ²z­û¸Ì­±§â¤u§@ªístockªºBÄæ¦ì©w¸qstock_item

®æ¦¡¤Æ±ø¥óª½±µ¥Î¤½¦¡¤U=MATCH(A1,stock_item,0)

furniture_0830.zip (6.47 KB)
¥Î¥\¨ì¥@¬É¥½¤é¨º¤@¤Ñ¡ã¡ã¡ã

TOP

google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 1# hkyan


   
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

ÁÂÁ¦U¦ì¸Ñµª,¦b¤W¶ÇªºexcelÀɦ¨¥\¤F.
¦ý¦P¤@©Û­YªG¥Î©ó¥t¤@­ÓÄÝODBC¶×¤J¸ê®ÆªºexcelÀÉ,«oµLªk¥¿½TÅã¥Üµ²ªG.
§V¤O¾Ç²ß¤¤,ÁÂÁ«e½ú

TOP

ÁÂÁÂHsieh«ü¾É, ²×©ó¦bODBC¶×¤J¸ê®ÆªºexcelÀɥΦ¹¤èªk¦¨¥\¤F.
§V¤O¾Ç²ß¤¤,ÁÂÁ«e½ú

TOP

        ÀR«ä¦Û¦b : ¬Ý§O¤H¤£¶¶²´¡A¬O¦Û¤v­×¾i¤£°÷¡C
ªð¦^¦Cªí ¤W¤@¥DÃD