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

[µo°Ý] ¿z¿ï¹ïÀ³¸ê®Æ

[µo°Ý] ¿z¿ï¹ïÀ³¸ê®Æ

½Ð±Ð¦U¦ì¥ý¶i

  ¤p§Ì§Ú³Ìªñ¦b¾ã²z¤½¥q¸ê®Æ¡A¥Ñ©ó¸ê®Æ¶qÃe¤j¡A»Ý¶i¦æ¸ê®Æ¾ã²z

¤p§Ì¦b¤½¥q¸Õ¤F³\¤[¤@ª½µLªk¦¨¥\

¾ã²z¸ê®Æ¤è¦¡»¡©ú¦p¤U

¦b "¾ã²z" ¶µ¥Ø¤¤ »Ý»P "­ì©ldata" ¶µ¥Ø¶i¦æ¤ñ¹ï¦p¦³¹ïÀ³¨ì¸ê®Æ«h¼Ðµù " O "

EX .  "¾ã²z"   A1Äæ¦ì¬° ®Æ¸¹     B2~I2¬°¶µ¦¸

"¾ã²z"  A2~A9 ·j´M "­ì©lDATA" ¬Û¹ïÀ³ A2~A9

¦p" ¾ã²z " A Äæ¦ì¥i¹ïÀ³¨ì "­ì©lDATA" BÄæ¦ì¶µ¦¸ «h¼Ð¼Ðµù " O "¡A¦pµLªk«hªÅ¥Õ

(µù: ¥Ñ©ó "¾ã²zSHEET" AÄæ¦ì³Ì«á¤@½X¦³ªÅ®æ¡A½Ð±Ð¸Ó¦p¦ó§R°£³o­ÓªÅ®æ©O?)

¬O§_¦³§ó§Ö§ó¤è«Kªº¤è¦¡¥i¥H¹F¨ì©O? ½Ð¦U¦ì¥ý¶i¨ó§U¸Ñ´b¡AÁÂÁÂ!!

¿z¿ï.rar (42.17 KB)
80 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

¦^´_ 7# dragonbx


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

TOP

¦³¤@­Ótrim spacesªºµ{¦¡¥i¯à¹ï§A¦³©ÒÀ°§U. ¥i¥H¥h±¼¦rÀY,¦r§ÀªºªÅ¥Õ.
¤£¹L§Y¨Ï¸g¹LÀ£ÁYÀÉ®×ÁÙ¬O¤Ó¤j,µLªk¤W¶Ç.
fangac

TOP

¦^´_ 6# chen_cook


    ¬Oªº¡A¥Ñ©ó§Úªº¸ê®Æ ¨Ï¥Î ½s¿è/¨ú¥N «á ¸ê®Æ«á­±³£¦³¤@ªÅ®æ¡A¨Ï¥Îvlookµ¥¨ç¼Æ§¡µLªk±o¨ì¸ê®Æ

³o¸Ó¦p¦ó³B²z©O?
80 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

Hsieh ¤j¤j¦^µªªº ½s¿è/¨ú¥N ¬O·|±N©Ò¦³ªÅ¥Õ³£¥N´«±¼!!!(¥»¨Òªºitem¬O¨S¦³°Õ¥B¤wª¾¥½§À¦³ªÅ¥Õ)
  §Ú·Q dragonbx  ­n°Ýªº¬Odata¤U¸ü®É,¨t²Î¤£©ú­ì¦]±a¥X¸ê®Æ¤¤<µLªk±oª¾ªºªÅ¥Õ>¦p (oracle¤¤export...),©óvlookup()®M¥Î®É¬Ý±o¨ì«o§ä¤£¨ì¸ê®Æ§a!!!

TOP

¦^´_ 4# chen_cook


    ½s¿è/¨ú¥N
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 1# dragonbx


     "¾ã²zSHEET" AÄæ¦ì³Ì«á¤@½X¦³ªÅ®æ¡A½Ð±Ð¸Ó¦p¦ó§R°£³o­ÓªÅ®æ©O
   j1 =trim($a1) ©¹¤U©Ô¦Ü³Ì«á,¦Acopy ­È§Y¥i.....

TOP

¦^´_ 2# register313


    «z~~¯u¬O¤Ó¯«©_¤F~~·PÁ¤j¤jªº«ü¾É~~
80 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¦^´_ 1# dragonbx

B2=IF(COUNTIF(­ì©lDATA!B:B,LEFT($A2,LEN($A2)-1))>0,"¡³","")
©Î
B2=IF(ISNUMBER(MATCH(LEFT($A2,LEN($A2)-1),­ì©lDATA!B:B,0)),"¡³","")

TOP

        ÀR«ä¦Û¦b : ¤Hªº¤ß¦a¬O¤@²¥¥Ð¡A¤g¦a¨S¦³¼½¤U¦nºØ¤l¡A¤]ªø¤£¥X¦nªºªG¹ê¡C -
ªð¦^¦Cªí ¤W¤@¥DÃD