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

¦p¦ó¸ò¾Ú«~¦W¡A§ì¥X¦¹«~¦Wªº©Ò¦³°â»ù

¦p¦ó¸ò¾Ú«~¦W¡A§ì¥X¦¹«~¦Wªº©Ò¦³°â»ù

§Ú¦³¤@­ÓÀÉ®× a.xls, ¬O «~¸¹        °â»ù ªº¸ê®Æ®w¦Cªí¡A¤º®e¨C­Ó¤ë³£·|¼W¥[

§Ú§Æ±æ¦b ¥t¤@­ÓÀÉ®×  b.xls ¡A·í§Ú¿é¤J¤@­Ó«~¸¹®É¡A·|¥h§ì¨ú a.xls ¤§¤¤¡A³o­Ó«~¸¹ªº°â»ù

¦]¬°¦P¤@¼Ë²£«~¡A¦³¤£¤@¼Ëªº°â»ù¡A§Ú§Æ±æ¯à¥Î¤½¦¡¥N¥X¥H«e´¿¸g°â¥Xªº»ù®æ¡A¤è«K¾Þ§@

¤j·§´N¹³¹Ï³o¼Ë¡A½Ð°Ý¡A³o¼Ëªº»Ý¨D¡A­n¥Î¤°»òvba funcion ¨Ó¹F¦¨¡H


°Ñ¦ÒÀÉ®×
https://www.dropbox.com/s/13gqtxtgf0ed2l3/lookup_list.xls?dl=0
¤½¶}¸gÅç¡A³Ð³y´¼¼z¡]§Ú¤S¤£¾a³o¹L¬¡¡^

¦^´_ 1# eigen


    B2 {=IF(COLUMN(A1)>COUNTIF($A$5:$A$999,$A$2),"",SMALL(IF($A$5:$A$999=$A$2,$B$5:$B$999),COLUMN(A1)))}
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¤Hªº§Ö¼Ö¡D¤£¬O¦]¬°¥L¾Ö¦³±o¦h¡A¦Ó¬O¦]¬°¥L­p¸û±o¤Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD