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

[µo°Ý] ¦p¦ó±Nsheet2¦³®Ä¤é´Á³Ì¤j­È¶×¤Jsheet1¤¤

[µo°Ý] ¦p¦ó±Nsheet2¦³®Ä¤é´Á³Ì¤j­È¶×¤Jsheet1¤¤

Sheet1ªºAÄæ¦ì¸ê®Æ¬O°ß¤@ª½¡A§Ú¦p¦ó¥Î¤ñ¹ïªº¤è¦¡±qsheet2¦hµ§¥B­«½Æ©Ê¤£¦Pªº¦³®Ä¤é´Á¡A§ä¥X¦³®Ä¤é´Á³Ì¤j­È(¦³®Ä¤é´Á³Ì¤[ªº)§â¥¦¶×¤J²Ä¤@¥÷Sheet1ªº«ü©w¦ì¸m¸Ì­±

¦pªþ¥[ÀÉ¡C·PÁ¤F¡I

¦³®Ä´Á­­³Ì¤[ªº¼Æ­È1.rar (1.85 KB)

103/12/10¨Ã«D¼Ð·Ç¤é´Á®æ¦¡
§âSHEET2ªºBÄæ§ï¦¨¥¿½T¤é´Á®æ¦¡
Sheet1!B2°}¦C¤½¦¡
{=MAXA(IF(OFFSET(Sheet2!$A$1,,,COUNTA(Sheet2!$A:$A),)=Sheet1!A2,OFFSET(Sheet2!$A$1,,1,COUNTA(Sheet2!$A:$A),),))}
¦V¤U½Æ»s
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥»©«³Ì«á¥Ñ pupai ©ó 2010-9-24 00:10 ½s¿è

坂¤j¦n
¥i§_À°§Ú¬Ý¬Ý§Ú
¦pªGsheet2 BªºÄæ¦ì­È¬O´X¤dµ§¥H¤W§Ú­n¦p¦ó­×§ï
{=1&TEXT(MAX((Sheet2!$A$2:$A$20=Sheet1!$A2)*DATE(LEFT(Sheet2!$B$2:$B$20,3),MID(Sheet2!$B$2:$B$20,5,2),RIGHT(Sheet2!$B$2:$B$20,2))),"yy/mm/dd")}
©ÎªÌ
{=MAXA(IF(OFFSET(Sheet2!$A$1,,,COUNTA(Sheet2!$A:$A),)=Sheet1!A2,OFFSET(Sheet2!$A$1,,1,COUNTA(Sheet2!$A:$A),),))}
§A»¡ªºSheet1!B2°}¦C¤½¦¡§Ú­n¦p¦ó¥[¤J§âSHEET2ªºBÄæ§ï¦¨¥¿½T¤é´Á®æ¦¡ªº¨ç¼Æ
ÁÂÁÂ

TOP

§ï¦¨¤é´Á¥ý¼W¥[¸É§U¦C
¢Ñ¢±=DATEVALUE(LEFT(B2,3)+1911&RIGHT(B2,6))
Àx¦s®æ¥k¤U¤p¤Q¦r§Ö³tÂI¤G¤U,¦A¾ãÄæCOPY¨ì¢ÐÄæ

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2010-9-24 19:03 ½s¿è

¦^´_ 3# pupai


    ¸ê®Æ­åªR
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

1.sheet2!b:b±N"/"¨ú¥N¬°"ªÅ¥Õ"
2.¼Ï¯Ã¤ÀªR¨ú³Ì¤j­È
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

1.sheet2!b:b±N"/"¨ú¥N¬°"ªÅ¥Õ"
2.¼Ï¯Ã¤ÀªR¨ú³Ì¤j­È
gong µoªí©ó 2010-9-25 21:01


±z¦n
sheet2!b:b±N"/"¨ú¥N¬°"ªÅ¥Õ"
   ¥i¥H­×§ï¤@¦¸µ¹§Ú¬Ý¶Ü
ÁÂÁÂ

TOP

¦^´_ 7# pupai


    ¿ï¨úBÄæ
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

Sheet1!B2°}¦C¤½¦¡
{=MAXA(IF(OFFSET(Sheet2!$A$1,,,COUNTA(Sheet2!$A:$A),)=Sheet1!A2,OFFSET(Sheet2!$A$1,,1,COUNTA(Sheet2!$A:$A),),))}
Hsieh µoªí©ó 2010-9-23 21:26



²¤Æ°}¦C¤½¦¡
=MAX((Sheet2!$A$2:$A$20=Sheet1!A2)*(Sheet2!$B$2:$B$20))
¾÷¾¹¤H¤T¤j©w«ß-«OÅ@¤HÃþ¡BªA±q©R¥O¡B«OÅ@¦Û¤v
§Úªº¤T¤j©w«ß-¥Í©R¡B¥Í¦s¡B¥Í¬¡

TOP

¥»©«³Ì«á¥Ñ gong ©ó 2010-9-27 12:34 ½s¿è

¦p°ÆÀÉ

1.gif (15.45 KB)

1.gif

¦³®Ä´Á­­³Ì¤[ªº¼Æ­È1.rar (40.05 KB)

ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

        ÀR«ä¦Û¦b : µêªÅ¦³ºÉ¡D§ÚÄ@µL½a¡AµoÄ@®e©ö¦æÄ@Ãø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD