ªð¦^¦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¿è

¦p¦ó¦b«Dµ¥¶¡¹jªº¦P¤@¦CÀx¦s®æ ¥Ñ¥ª¦Ü¥k¿ï¥X²Ä¤@­Ó«D¹sªº¼Æ­È.jpg
2018-2-26 22:52

¦^´_ 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

ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

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 : ¤Hªº²´·úªø¦b«e­±¡A¥u¬Ý¨ì§O¤Hªº¯ÊÂI¡Aµ·²@¬Ý¤£¨ì¦Û¤vªº¯ÊÂI¡C
ªð¦^¦Cªí ¤W¤@¥DÃD