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

[µo°Ý] ¸ûÃøªº¬dªí¡A½Ð°ª¤âÀ°¦£

¦^´_ 10# king0331

=INDIRECT(TEXT(MAX(IF(¦¹³B¥[ªí®æ¦WºÙ!C$3:AZ$23=BC10,ROW($4:$24)*1000+COLUMN(C:AZ),1256)),"¦¹³B¥[ªí®æ¦WºÙ!R0c000"),)&""
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¨C¤ÑµL©Ò¨Æ¨Æ¡A¬O¤H¥Íªº®ø¶OªÌ¡A¿n·¥¡B¦³¥Î¤~¬O¤H¥Íªº³Ð³yªÌ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD