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

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

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

§Ú­n¥Î¬õ¦âªº±ø¥ó§ä¨ìÂŦ⪺­È¦^¶Ç

§Ú¥Î¤@¯ëªºVLOOKUP,HLOOKUP,LOOKUP
³£µLªk¦^¶Ç¬O¦]¬°¦X¨ÖÀx¦s®æªºÃö«Y¶Ü¡H

sshot-2.png (59.66 KB)

¹Ï

sshot-2.png

¬¡­¶Ã¯1.rar (14.42 KB)

ÀÉ

³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

TOP

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

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

TOP

¥i¬O³o¼Ë§ÚAK3¨ìAZ3ªº´N§ä¤£¨ì¤F
¥i§_¶¶«KÁ¿¸Ñ¤½¦¡¤Î°}¦C¤X
¦n·Q¾Ç¡P¡P

TOP

©Ò¥H§Ú¨C¤Ñ§ó§ï«á¥LÁÙ¬O¥i¥H¦Û¤w§ó·s¶Ü¡H

TOP

¦^´_ 5# king0331

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

TOP

¤º®e¨C¤Ñ·|§ï¡A¦ýÀx¦s®æªº®æ¦¡¤£·|°Ê
©Ò¥H§Ú§ó§ï¤º®e¥L¤@¼Ë·|§ä±o¨ì
¥u¬O§Ú²Ä¤@±ÆªºAK3¨ìAZ5´N¨S¿ìªk§ä¨ì¤F
¦³ÂI¥i±¤~¡§~

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

¥i¥H¤F¦¨¥\¤F¡A³o¯u¬OÀ°¤F§Ú¤@­Ó¤j¦£

TOP

¦A¸ß°Ý¤@¤U¡A¦b¤£¦P¤u§@ªí¤W¡A´N¸ê®Æ§ä¤£¨ì¤F­C¡I¡I¡I

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡µLªk¾B¾×¡j©È®É¶¡®ø³u¡Aªá¤F³\¦h¤ß¦å¡A·QºÉ¦U¦¡¤èªk­n¾B¾×®É¶¡¡Aµ²ªG¬O¡G®ö¶O¤F§ó¦h®É¶¡¡A¥B¤@µL©Ò¦¨¡I
ªð¦^¦Cªí ¤W¤@¥DÃD