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

[µo°Ý] ½Ð±Ð: ¦p¦ó¦b«Dµ¥¶¡¹jªº¦P¤@¦CÀx¦s®æ ¥Ñ¥ª¦Ü¥k¿ï¥X²Ä¤@­Ó«D¹sªº¼Æ­È

[µo°Ý] ½Ð±Ð: ¦p¦ó¦b«Dµ¥¶¡¹jªº¦P¤@¦CÀx¦s®æ ¥Ñ¥ª¦Ü¥k¿ï¥X²Ä¤@­Ó«D¹sªº¼Æ­È

¥»©«³Ì«á¥Ñ ABK ©ó 2018-2-26 22:55 ½s¿è

¦^´_ 1# ABK


   =LOOKUP(,0/N(INDIRECT({"K","I","G","F","C","A"}&1)),N(INDIRECT({"K","I","G","F","C","A"}&1)))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

ÁÂÁÂML089¤j !     ¥i¥H¤F!    ·P®¦!   ·P®¦!

TOP

google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 4# hcm19522

ÁÂÁ hcm¤j!   ±z³o¼Ëªº¤èªk¤]«Ü¦n¥Î!   ÁÂÁ±z!

TOP

¦^´_ 2# ML089


ML089¤j±z¦n!     «á¨Ó¨Ï¥Î®É  µoı¤½¦¡¦³®É­Ô·|§ì¿ù´Ó!

TOP

¦^´_ 6# ABK
À£ÁYÀÉ·l·´¡A½Ð¦A¸É¤@­Ó
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

=1/LOOKUP(2,1/N(OFFSET(A4,,{11,10,7,5,4,2,1})))

TOP

¦^´_ 7# ML089


    ML¤j±z¦n!  §Ú¬O¥ÎExcel 2016ª©¡A §Ú§ä¨ä¥Lª©ªºExcel ¦A¶Ç¤W¨Ó!

TOP

¦^´_ 8# ­ã´£³¡ªL


­ã´£¤j±z¦n!   ¹J¨ì0.5¥H¤Uªº­È ·|³Q©¿²¤ !

TOP

        ÀR«ä¦Û¦b : ¦³Ä@©ñ¦b¤ß¸Ì¡A¨S¦³¨­Åé¤O¦æ¡A¥¿¦p¯Ñ¥Ð¤£¼½ºØ¡A¬Ò¬OªÅ¹L¦]½t¡C
ªð¦^¦Cªí ¤W¤@¥DÃD