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

[µo°Ý] ¬Û¦P­È¬D¥X¨Ã±Æ§Ç((¨D¸Ñµª,·Q¤£¥X¨Ó- -

[µo°Ý] ¬Û¦P­È¬D¥X¨Ã±Æ§Ç((¨D¸Ñµª,·Q¤£¥X¨Ó- -

¤£¦n·N«ä,¦pªGµo¥Í¹³,¹Ï¤ù³o­Óª¬ªp
¸Ó«ç»ò¸Ñ¨M? ¬Q¤ÑÁÙ¸I¨ì³o­Ó°ÝÃD!!

q:¥i¯à¬Y´X¶¡¼t°Ó,µ¹ªº»ù¿ú³£¤@¼Ë,Åܱo¨S¿ìªkÅã¥Ü£»£»£»((±j¸I!?

1.·QÅý¥L³£Åã¥Ü¥X¨Ó ,§Y¨Ï¶i»ù³£¤@¼Ë
2.¦³¤½¦¡¬O B2:E2 ¸õ¦â³¡¤À ,¥i¥H©¹¤U©Ô ¤@¦¸°µÅܦâ¶Ü?
(¥Ø«eªº¤èªk¥u¯à¤@­Ó¤@­Ó³]©w)


¨D¸Ñµª,ÁÂÁ§A­Ì>___<

µo°Ý2.jpg (56.82 KB)

µo°Ý2.jpg

¦^´_ 1# qq910057


    q:¥i¯à¬Y´X¶¡¼t°Ó,µ¹ªº»ù¿ú³£¤@¼Ë,Åܱo¨S¿ìªkÅã¥Ü£»£»£»((±j¸I!?

1.·QÅý¥L³£Åã¥Ü¥X¨Ó ,§Y¨Ï¶i»ù³£¤@¼Ë
­Y¨â®a¤@¼Ë®É,Åã¥Ü¤@®a©Î¤G®a¡H

2.¦³¤½¦¡¬O B2:E2 ¸õ¦â³¡¤À ,¥i¥H©¹¤U©Ô ¤@¦¸°µÅܦâ¶Ü?
(¥Ø«eªº¤èªk¥u¯à¤@­Ó¤@­Ó³]©w)
­n°µ«ç¼ËÅܦâ½Ð¦A»¡©ú²M·¡
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 2# ML089


    1.­n³£Åã¥Ü,´X®a¤@¼Ë³£Åã¥Ü
   2.©Ò¿×Åܦâ¬O«ü ³Ì§C»ùÅܦâ(¥­»ù¦ü¥G¤£·|ÅÜ)
    ¦]¬°§Ú²{¦b¬O­n¤@­Ó¤@­Ó¥h³]©wÅܦâ
    §Ú·Q§ä¤èªk §â²Ä1 2­ÓÅܦâ«á,¿ï¨ú©¹¤U©Ô  ¤U­±·|¦Û°Ê¬D¿ï¥X³Ì§C»ùÅܦâ

TOP

¦^´_ 3# qq910057


1.­n³£Åã¥Ü,´X®a¤@¼Ë³£Åã¥Ü
¦^ÂÐ: G2 =TRIM(IF(B2=F2,B$1,"")&" "&IF(C2=F2,C$1,"")&" "&IF(D2=F2,D$1,"")&" "&IF(E2=F2,E$1,""))
¤½¦¡¤U©Ô½Æ»s


2.©Ò¿×Åܦâ¬O«ü ³Ì§C»ùÅܦâ(¥­»ù¦ü¥G¤£·|ÅÜ)
    ¦]¬°§Ú²{¦b¬O­n¤@­Ó¤@­Ó¥h³]©wÅܦâ
    §Ú·Q§ä¤èªk §â²Ä1 2­ÓÅܦâ«á,¿ï¨ú©¹¤U©Ô  ¤U­±·|¦Û°Ê¬D¿ï¥X³Ì§C»ùÅܦâ

¦^ÂÐ: ¿ï¾ÜB2:E7¡A³]©w®æ¦¡¤Æ±ø¥ó¦p¤U
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 4# ML089


    ÁÂÁ§A~¤£¦n·N«ä,¦p§Ú²{¦b§Ú­n 0¤£¦C¤J­pºâªº¸Ü? ¥i¥H¶Ü?

§Ú¦bªþ¤W¤@±i¹Ï     


§Ú¬O¥Î H4 ¸Õ°µ

§Ú·Q­nH4  (B4:E4) ¦³0³£¤£¦C¤J­pºâ

©Ò¥HH4¥u·|Åã¥ÜB12®®ª@(¦©%)

¦A·Ð³Â§A¤F£»£»£»¤Ó½ÆÂø¤F- """-

1.jpg (76.47 KB)

1.jpg

TOP

£«£«~~~¨S¨Æ,§Ú¦A¸Õ¸Õ¬Ý,§Ú­è­è±a¿ù¼Æ­È<<©êºp!!!

TOP

        ÀR«ä¦Û¦b : ¤@¥y·Å·xªº¸Ü¡A´N¹³©¹§O¤H¨­¤WÅx­»¤ô¡A¦Û¤v·|ªg¨ì¨â¤Tºw¡C
ªð¦^¦Cªí ¤W¤@¥DÃD