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

[µo°Ý] EXCEL µLªkÅã¥Ü¹ïÀ³ªº¼Æ¦r ·s¤â½Ð±Ð

[µo°Ý] EXCEL µLªkÅã¥Ü¹ïÀ³ªº¼Æ¦r ·s¤â½Ð±Ð

1. ¦b³o­ÓÀɮפ¤ ¬¡­¶Ã¯1.zip (15.59 KB)   ¬°¤°»ò B2-¨ìB6 ¦pªG¬O¤â°Ê¿é¤J¼Æ­È  C2-C6¼Æ¦r´N¥i¥HÅã²{   ¦pªGB2-B6¥Î=¬Y¤@®æ  ¼Æ¦r´NÅã²{¤£¥X¨Ó   ¦]¬°¦³¤j¤j¥i¥H§iª¾­ì¦]¶Ü??



2.¥t¥~²Ä¤G­Ó°ÝÃD¸òÀÉ®×µLÃö

°²³]§Ú¦bA1³o­ÓÀx¦s®æ¤¤ §Æ±æ¯àÅã²{¥X B1 ©ÎC1¸Ìªº¤å¦r B1Àu¥ý

1.¦pªGB1¦³¤å¦r A1 Åã²{B1 ¤å¦r
2.¦pªGB1 C1³£¦³¤å¦r A1Åã¥ÜB1¤å¦r
3.¦pªGB1ªÅ¥Õ C1¦³¤å¦r A1Åã¥ÜC1¤å¦r
4.¦pªGB1 C1³£ªÅ¥Õ ,«hA1 ¤]ªÅ¥Õ

Àx¦s®æ¬O¤å¦r ¤£¬O¼Æ¦r
½Ð°Ý³o­n«ç»ò¼g ¤Q¤À·PÁ¦^µª !!!

¦^´_ 1# logybelle

°ÝÃD¤@
B2:B8¬°¤å¦r(µ²§ÀÁÙ¦³¤@­Ó¬Ý¤£¨£ªº¦r¤¸)¡ARÄ欰¼Æ¦r¡A©Ò¥H¬d¸ß¤£¨ì¡A¥Ø«e
§A¦Û¤vKEYIN®É¬°¼Æ¦r¡A´N¥i¥H¬d¸ßªº¨ì


°ÝÃD¤G   
A1
=IF(B1<>"",B1,IF(C1<>"",C1,""))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 2# ML089

°ÝÃD¤@
½Ð°Ý¦³¸Ñ¨M¿ìªk¶Ü   ÁÙ¬O­n¤@­Ó¤@­Ó ¦Û¤vKEY

°ÝÃD¤G
½Ð°Ý ¦pªG±ø¥ó Åܦ¨¤T­Ó©O  Åܦ¨¦³ B1 C1 D1 ¤@¼ËB1Àu¥ý µM«áC1 ¦A¨ÓD1 ³Ì«á¦pªG³£¨S¦³ ´NªÅ¥Õ

·PÁ±zªº¦^µª   À°¤F«Ü¤jªº¦£

TOP

¢°¡D¿ï¨ú¾ã±i¤u§@ªí
¢±¡D°õ¦æ¡e¨ú¥N¡f¡A«ö¦í Alt ¤£©ñ¡A¥Î¡e¼Æ¦rÁä¡f¿é¤J 160¡A©ñ¶} Alt¡A
¡@¡@¡e¨ú¥N¦¨¡f¤£­n¿é¤J¡A«ö¡e¥þ³¡¨ú¥N¡f

TOP

¦^´_ 3# logybelle

°ÝÃD¤@
¥Î ­ã¤j ªº¤èªk

°ÝÃD¤G
=IFERROR(INDEX(B1:F1,MATCH("*",B1:F1,)),"")
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 5# ML089

ÁÂÁ ¨â¦ì¼ö¤ßªº¤j¤j¦^µª

°ÝÃD¤@  
­è­è¸Õ¤F¤@¤U  ¥Î¤@±i¤u§@ªí ¥i¥H¦¨¥\  ¥i¬O¦pªG ¦P®É¥Î¤T±i  «ç»ò«ö³£ ¨ú¥N¤£¤F  ¤£ª¾¹D¬°¤°»ò

°ÝÃD¤G
¦pªG ·Q­n¥ÎªºÀx¦s®æ  ­è¦n¤£¦A¦P¤@¦C   ¨Ò¦p: B2  D2  F2  ³o¤T®æ  
½Ð°Ý ³o­n«ç»ò¼g ¤ñ¸û¦n   
¤£¦n·N«ä   ¦³ÂIÅo¶Û   ¯uªº«Ü·PÁÂÀ°¦£!!!

TOP

¦^´_ 6# logybelle


    ­Y§PÂ_¼Æ¶q¤£¦h¡A¥Î 2¼Ó ªºIF¨ç¼Æ¼gªk´N¥i¥H
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 7# ML089


ÁÂÁ±zªº¦^µª

¦pªG¥Î¤G¼ÓªºIF¼gªk

¦A¦h¤@­ÓÀx¦s®æ   ¤À§O¬O B1 C1 ¸òF1   ½Ð°Ý­n«ç»ò¼g

¤Q¤À·PÁ±zªºÀ°¦£

TOP

¦^´_ 8# logybelle


°ÝÃD¤G   
A1
=IF(B1<>"",B1,IF(C1<>"",C1,IF(F1<>"",F1,"")))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 9# ML089

ÁÂÁ±zªº¼ö¤ßÀ°¦£  °ÝÃD¤w¸g¸Ñ¨M  ·P¿E¤£ºÉ

¦³ªÅ­n¨Ó¦n¦n¬ã¨s EXCEL ¤F   ÁÂÁÂ!!!

TOP

        ÀR«ä¦Û¦b : ¦³¦h¤Ö¤O¶q´N°µ¦h¤Ö¨Æ¡A¤£­n¤ß¦sµ¥«Ý¡Aµ¥«Ý¤~·|¸¨ªÅ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD