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

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

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

¦U¦ì¤j¤j¦n, ¦pÃD Ãö©ó Excel ¤½¦¡

=INDEX(A:A .......)

¦b³o­Ó¤½¦¡¸Ì­±ªº A:A ¬O¨D¥X¨Óªº, ¦³¥i¯à¬O B:B ... C:C ... Y:Y

½Ð±Ð¦U¦ì¤j¤j, ­n«ç»òÅý¥L¯à°÷´À´«?

·P¿E¤£ºÉ¤F

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

TOP

¦^´_ 2# ML089


    ¤j¤j§A¦n

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

«Ü·PÁ§Aªº¦^ÂÐ

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

¦^´_ 4# ML089


    ¤j¤j«D±`·PÁ§A~

³o¼Ë¤l¨S¿ù!!!

·PÁ§AµL¨pªº¤À¨É»P¦^ÂÐ~

TOP

        ÀR«ä¦Û¦b : «H¤ß¡B¼Ý¤O¡B«i®ð¤TªÌ¨ã³Æ¡A«h¤Ñ¤U¨S¦³°µ¤£¦¨ªº¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD