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

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

¦^´_ 2# ­ã´£³¡ªL

½d³ò C$7:AZ$23¡A¬O§_»Ý­n§ï¬° C$3:AZ$23
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 5# king0331

§A¬O­n§ó§ï¸ê®Æ½d³ò¡A©Î¬O§ó§ï¤º®e?
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 7# king0331


³o¤£¬O¤@ºûªí, µLªk¨Ï¥Î¤W­±ªº¤½¦¡,
BD10 °}¦C¤½¦¡:
=INDIRECT(TEXT(MAX(IF(C$7:AZ$23=BC10,ROW($8:$24)*1000+COLUMN(C:AZ),1256)),"!R0c000"),)&""

¡Õ°}¦C¤½¦¡¿é¤Jªk¡Ö
¿é¤J©Î­×§ï¤½¦¡§¹¦¨«á¡A´å¼Ð¯d¦b¡e½s¿è¦C¡f¡A¥ý¤£­n«öEnter¡A
¦P®É«ö¦í¡eShift + Ctrl¡f¤£©ñ¡A¦A«ö¡eEnter¡f¡C


±N­ã¤jªº¤½¦¡­×§ï¤@¤U´N¥i¥H
=INDIRECT(TEXT(MAX(IF(C$3:AZ$23=BC10,ROW($4:$24)*1000+COLUMN(C:AZ),1256)),"!R0c000"),)&""
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 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 : ¯à¥I¥X·R¤ß´N¬OºÖ¡A¯à®ø°£·Ð´o´N¬O¼z¡C
ªð¦^¦Cªí ¤W¤@¥DÃD