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

[µo°Ý] Àx¦s®æA10ªº10¬°ÅܼƮɤ½¦¡­n«ç»ò¿é¤J?

[µo°Ý] Àx¦s®æA10ªº10¬°ÅܼƮɤ½¦¡­n«ç»ò¿é¤J?

½Ð±Ð¦U¦ì¥ý¶i¡A¦³­Ó¤p¤pªººÃ°Ý¡A
Àx¦s®æ«á¤èªº¦C¼Æ¥i¥H¥Î¤½¦¡¨ú¥N¶Ü?

¨Ò¦p­ì¥»¿é¤Jªº¤½¦¡¬O"=A10"¡A
¦ý§Úªº10¬O¥ÎMATCH¨ç¼Æ¨D¥Xªº¡A
¨º§Úªº¤½¦¡­n«ç»ò½ü¤J?

=A&MATCH()?
="A(MATCH())"?

«ç»ò¿é¤J³£¤£¹ï°Ú~@_@
ÁÙ¬O¥L¸ò¥»¤£¯à·íÅܼƳB²z?

=INDIRECT("A"&MATCH("QQ",B:B,))
§äBÄ榳"QQ" ,¨ä¹ïÀ³AÄ檺­È

TOP

¦^´_ 2# hcm19522


    ·PÁ«ü¾É

TOP

¦^´_ 1# eghost

°£INDIRECT¨ç¼Æ
¤]¥i¥Î OFFSET¨ç¼Æ
¨Ò¦p
=OFFSET(A1,MATCH(10,F:F,)-1,)

PS: MATCH(10,F:F,) = 10
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ºÉ¦h¤Ö¥»¥÷¡A´N±o¦h¤Ö¥»¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD