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

ÃøÃD!!! ¶Ç¦^Àx¦s®æ¤º®e¡A¥Ñ¥k¦Ü¥ª

ÃøÃD!!! ¶Ç¦^Àx¦s®æ¤º®e¡A¥Ñ¥k¦Ü¥ª

¥»©«³Ì«á¥Ñ kevin21522886 ©ó 2013-10-16 16:25 ½s¿è

1.JPG
2013-10-16 16:13


½Ð±Ð¦U¦ì°ª¤â!!¤p§Ì¥Ø«e¦³¤@¸ê®ÆÀÉ¡A°O¿ý¬ÛÃö¹s¥óªºª©¦¸§ó·s¾úµ{(¦p¤W¹Ï)¡C¥Ø«eªº°ÝÃD¬O¡A§Æ±æ¯à¦³¦U¹s¥ó³Ì·sª©¦¸ªº¸ê°T(²z·Q¬°¤U¹Ï)¡A¤£ª¾¦³¤°»ò¤½¦¡¯à¿ì¨ì¡C¥H¤W³Â·Ð¤F¡A·PÁÂ!!

02.JPG
2013-10-16 16:19

001.zip (6.01 KB) ¦^´_ 1# kevin21522886

©êºp¡A§Ñ¤Fªþ¤WEXCELLÀÉ~~

TOP

­Y¤£¨Ï¥Î¥¨¶°ªº±¡ªp¤U¡A¥i¾î¦V±N¨C­ÓÀx¦s®æªº¤º®e¦ê°_¨Ó¡A¦A¨ú³Ì¥kÃ䪺¦r¤¸¡AÀ³¸Ó´N¬O³Ì°ªª©¦¸¤F¡C
G2Àx¦s®æªº¤º®eÀ³¸Ó¬O"=RIGHT(CONCATENATE(B2,C2,D2,E2,F2),1)"
PS.
1¡BCONCATENATE()³Ì¦h¥i¦³30­Ó¤Þ¼Æ¡A¬G³Ì¦h¥i§P©w¾î¦V30­ÓÀx¦s®æªº¤º®e¡C
2¡BCONCATENATE()¤]¥i§ï¥Î"&"¨Ó´À¥N¡A¨Ò¦p¡G"=RIGHT(B2 & C2 & D2 & E2 & F2,1)"¡]&«e«á¥i¥H¤£»ÝªÅ®æ¡^

¥H¤W¬O¤p§Ìªº©å¨£¡A­Y¦³¨ä¥¦¿ìªk¡A¤]½Ð¤£§[«ü±Ð¡AÁÂÁ¡C
George Ma

TOP

G2 =LOOKUP("ùÜ",B2:F2)
¤U©Ô½Æ»s¤½¦¡
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 3# georgema


   ¦n¤èªk¡A·PÁÂ!!

TOP

¦^´_ 4# ML089

¤p§Ì¸Õ¹L¥i¦æ³á!! ¦ý¤£°÷±M·~¤£ª¾¹D³o¤½¦¡ªº­ì²zªü~~ÁÙ¦³¸Ì­±¤¤¤å¦rªº·N«ä@@
¤è«K¦h°µ¸ÑÄÀ¶Ü!?¨þ¨þ

=LOOKUP("ùÜ",B3:F3)

TOP

=LOOKUP("ùÜ",B3:F3)

§Q¥Î LOOKUP ¬d¸ß¯S©Ê¡AùÜ ¦r¬°ÁcÅ餤¤å½X¤¤¸û¤j½X¼Æ¡A¥u­n B3:F3 ¤¤ªº¤¤¤å¦r½X³£¤p©ó ùÜ¡A
LOOKUP ¦ÛµM·|§ä¨ì³Ì«á¤@­Ó¦^¶Ç¡C
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 7# ML089

¯u¬O°ª©Ûªü~ ·PÁ¤F¡A¨ü¯q¨}¦h!!

TOP

        ÀR«ä¦Û¦b : §Ñ¥\¤£§Ñ¹L¡A§Ñ«è¤£§Ñ®¦¡C
ªð¦^¦Cªí ¤W¤@¥DÃD