ªð¦^¦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
2018-8-30 10:59
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

ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 1# hkyan


   
¥¼©R¦W.png
2018-8-30 15:40
¾Ç®üµ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 : ­n¥Î¤ß¡A¤£­n¾Þ¤ß¡B·Ð¤ß¡C
ªð¦^¦Cªí ¤W¤@¥DÃD