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

[µo°Ý] ¦p¦óÅýÁ`ªíÂà¤Æ¬°¤T±i©ú²Óªí

¥»©«³Ì«á¥Ñ p212 ©ó 2013-6-21 08:50 ½s¿è

¦^´_ 2# Bodhidharma
½Ð°Ý
=INDEX(Á`ªí!A$1:A$65536,SMALL(IF(Á`ªí!$B$1:$B$1000=$A$1,ROW(Á`ªí!$B$1:$B$1000),4^8),ROW(1:1)))&""
¬õ¦r³¡¥÷&""¥Î·N¬°¦ó¡H
1¡B¥Î¥H¦^¶Ç²Õ¦X¤½¦¡µ²ªG§¡¬°¡u¤å¦r¡v«¬ºA§e²{¡H
2¡B§í&""¥i³w¤©¬Ù²¤¡H

TOP

¥»©«³Ì«á¥Ñ Bodhidharma ©ó 2013-6-20 23:21 ½s¿è

¦^´_ 1# s7659109

¦b¦UªíªºA1Àx¦s®æ¿é¤J³f¸¹(Sheet A001´N¿é¤JA001,Sheet A002´N¿é¤JA002...)
3±iSheetªºA3Àx¦s®æ°}¦C¤½¦¡(CTRL+SHIFT+ENTER¿é¤J)
  1. =INDEX(Á`ªí!A$1:A$65536,SMALL(IF(Á`ªí!$B$1:$B$1000=$A$1,ROW(Á`ªí!$B$1:$B$1000),4^8),ROW(1:1)))&""
½Æ»s¥N½X
¤U©Ô¥k©Ô

TOP

        ÀR«ä¦Û¦b : ¨Ã«D¦³¿ú¾{¬O§Ö¼Ö¡A°Ý¤ßµL·\¤ß³Ì¦w¡C
ªð¦^¦Cªí ¤W¤@¥DÃD