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

[µo°Ý] Sheet1ªºAÄæ¥u­n¦³¥X²{¡¹ªº¸Ü,¨º»ò,¦³¡¹ªº¸Ó¦C¸ê®Æ,¥þ³¡³£·|¨ìSheet2

[µo°Ý] Sheet1ªºAÄæ¥u­n¦³¥X²{¡¹ªº¸Ü,¨º»ò,¦³¡¹ªº¸Ó¦C¸ê®Æ,¥þ³¡³£·|¨ìSheet2

§A¦n,

§Ú·Q½Ð°Ý¤@­Ó°ÝÃD

Sheet1ªºAÄæ¥u­n¦³¥X²{¡¹ªº¸Ü,¨º»ò,¦³¡¹ªº¸Ó¦C¸ê®Æ,¥þ³¡³£·|¨ìSheet2

½Ð°Ý,³o¼Ëªº¤½¦¡,§Ú­n«ç»ò¥h³],½ÐÀ°¦£tks

¥»©«³Ì«á¥Ñ p212 ©ó 2013-11-19 13:34 ½s¿è

¦^´_ 1# KOTOHO
½Ð¤W¶Ç½d¨ÒÀÉ¡A©Î¦A¸É¥R»¡©ú±z¨ä¥LÄæ¦ì°t¸mª¬ªp¥H«K°Ñ¦Ò¡AÁÂÁ¡I
°Ñ¦Ò¡G¥i¯à¨Ï¥ÎINDEX»PSMALL¨ç¼Æ¡A¨Ã·fShift+Ctrl+Enter¸Ñ¨M°ÝÃD

TOP

§A¦n¡A

ªþ¥ó¦p¤U¡CÁÂÁ¡C

Book1.rar (2.57 KB)

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2013-11-19 15:47 ½s¿è

¦^´_ 3# KOTOHO
1¡B½Ð¦bSheet2¤u§@ªí¤§A1Àx¦s®æ¿é¤J¡¹
2¡B½Ð¦bSheet2¤u§@ªí¤§A3Àx¦s®æ¿é¤J
=INDEX(Sheet1!B:B,SMALL(IF(Sheet1!$A$1:$A$1000=$A$1,ROW(Sheet1!$A$1:A$1000),4^8),ROW(1:1)))&""
¦A«öShift+Ctrl+Enter (±Ä¥Î°}¦C¤½¦¡)
3¡B©¹¥k¡B©¹¤U½Æ»s¤½¦¡§Y¥i
½Ð°Ñ¦Ò¡I

FIG.JPG (84.96 KB)

FIG.JPG

TOP

½Ð°Ýp212:

¤½¦¡¸Ìªº4^8¬O¥Nªí¤°»ò·N«ä?

¥t¥~,¦³­Ó°ÝÃD,¨ä¤¤¤@Äæ¬O¤é´Á,°}¦C¤½¦¡±a¥X¨Óªº¤é´ÁÅܦ¨"41390"

¦³¤°»ò¤è¦¡¥i¥H§JªA¤é´Áªº°ÝÃD¶Ü?

TOP

¥»©«³Ì«á¥Ñ KOTOHO ©ó 2013-11-20 09:59 ½s¿è

½Ð°Ýp212:

¤½¦¡¸Ìªº4^8¬O¥Nªí¤°»ò·N«ä?

¥t¥~,¦³­Ó°ÝÃD,¨ä¤¤¤@Äæ¬O¤é´Á,°}¦C¤½¦¡±a¥X¨Óªº¤é´ÁÅܦ¨"41390"

¦³¤°»ò¤è¦¡¥i¥H§JªA¤é´Áªº°ÝÃD¶Ü?

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2013-11-20 12:07 ½s¿è

¦^´_ 6# KOTOHO
1¡Bºâ³N¹Bºâ¤l^ (²æ¦r²Å¸¹)¥Nªí·N¸q¬°¡u­¼¾­¡v¡A¬G4^8=65536¡C
(´NExcel 2003¦Ó¨¥¡A¦C¼Æ·¥­­²Ä65536¦C¤@¯ë¤£·|¦³¼Æ¾Ú¡A¦h¬°ªÅªºÀx¦s®æ¡C)

2¡B¡u¼Æ¦r®æ¦¡¡v¤é´ÁÂà´«¥i¥ÎTEXT¨ç¼Æ¸Ñ¨M
¥H±zªº½d¨ÒÀɦӨ¥¡A­YSheet1¤§Àx¦s®æF2¿é¤J2013/11/19¡A±ý©óSheet2¤§Àx¦s®æE3§e²{¥Á°ê¾ä®æ¦¡102/11/19¡A«h©óSheet2¤§Àx¦s®æE3­×§ï¤½¦¡¬°
=TEXT(INDEX(Sheet1!F:F,SMALL(IF(Sheet1!$A$1:$A$1000=$A$1,ROW(Sheet1!$A$1:E$1000),4^8),ROW(1:1)))&"","EE/MM/DD")
«öShfit+Ctrl+Enter¿é¤J¤½¦¡
¨ä¥L¤é¾ä®æ¦¡¥i°Ñ·ÓExcel¤¤TEXT¨ç¼Æªº»¡©ú
½Ð°Ñ¦Ò¡I

fig.JPG (73.61 KB)

fig.JPG

TOP

ÁÂÁÂP212ªº¦^µª

¤£¹L¥[¤FTEXT¤§«á,¹J¨ì¼Æ¶q,¤]¦Û°ÊÂà´«¦¨¤é´Á®æ¦¡¤F¡C¼Æ¦r15Åܦ¨1900/01/15

TOP

¤£¹L§Ú¨â­Ó¤½¦¡³£¦³¥Î,¤é´ÁªºÄæ¦ì´N¥[TEXTªº¤½¦¡

ÁÂÁÂÀ°¦£

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