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

[µo°Ý] Ãö©ó Excel ¤½¦¡

=INDEX(INDIRECT("A:A"), ... )
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_  ML089


    ¤j¤j§A¦n

½Ð°Ý¬O¥[¤WINDIRECTµM«á±q¸Ì­±¥h°µÅܤƶܡH

«Ü·PÁ§Aªº¦^ÂÐ
EGBT µoªí©ó 2018-8-3 06:52



§A¤£¬O»¡ A:A¡BB:B ... ¬O¨D¥X¨Óªº¡A±NÅܼƩÎÀx¦s®æ±a¤J®M¤J¡C

=INDEX(INDIRECT("A:A"), ... )

A1 ="A:A"
=INDEX(INDIRECT(A1), ... )
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : Ä@­n¤j¡B§Ó­n°í¡B®ð­n¬X¡B¤ß­n²Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD