- ©«¤l
- 37
- ¥DÃD
- 9
- ºëµØ
- 0
- ¿n¤À
- 61
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows7
- ³nÅ骩¥»
- office 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2011-4-26
- ³Ì«áµn¿ý
- 2014-7-28
|
¥»©«³Ì«á¥Ñ sax868 ©ó 2012-5-8 12:10 ½s¿è
not ok.rar (55.18 KB)
¦^´_ 9# Hsieh
·PÁ¶W¯Åª©¥Dªº±Ï©R¤§®¦!! ¶W¯Å¦n¥Î!¤j·§µ¥2¤ÀÄÁµª®×¥þ¶]¥X¨Ó¡A³o¯uªº¤Ó¯«©_¤F!!
±µ¤U¨Óªº²Ä¤GÓ°ÝÃDÁÙ±o¦A·Ð½Ð¶W¯Åª©¥DÀ°§Ú¸Ñ¨M...
§Ú¸ÕµÛ¼g¨ç¼ÆµM«á¥Î¿ý¥¨¶°ªº¤è¦¡¥i¬OµLªk¨C±i¤u§@ªí³£¤@°_§ï¡A¥H¤U¬O§Úªº»Ý¨D¡G
¨C¤@±i¤u§@ªí¸ÌFilter(Array("Currency", "DATA", "Updated Data")ªºAI12¦ÜAI300Ȭ°:
YC1='Updated Data'¸ÌªºA:AÄæ¥BA12='Updated Data'!¸ÌªºD: DÄæ¥BJ12='Updated Data'!¸ÌªºM:MÄæ¡A
«hAI12Ȭ°'Updated Data'!AL:ALÄæ¸Ì¬Û¹ïÀ³ªºÈ¡A¨Ã¥BA12¦ÜA300ÈY¬°ªÅ®æ¡AAI12¦ÜAI300Ä欰ªÅ®æ¡AY¦³È«h»Ýpºâ¡FYAI12¦ÜAI300Äæ¦ìÈ¥X²{¹s«h·N±N¨äȳ]¬°ªÅ®æ¡C
¨C¤@±i¤u§@ªí¸ÌFilter(Array("Currency", "DATA", "Updated Data")ªºAU12¦ÜAU300Ȭ°:
YC1='Updated Data'¸ÌªºA:AÄæ¥BA12='Updated Data'!¸ÌªºD: DÄæ¥BJ12='Updated Data'!¸ÌªºM:MÄæ¡A
«hAI12Ȭ°'Updated Data'!AX:AXÄæ¸Ì¬Û¹ïÀ³ªºÈ¡A¨Ã¥BA12¦ÜA300ÈY¬°ªÅ®æ¡AAU12¦ÜAU300Ä欰ªÅ®æ¡AY¦³È«h»Ýpºâ¡FYAU12¦ÜAU300Äæ¦ìÈ¥X²{¹s«h·N±N¨äȳ]¬°ªÅ®æ¡C
Á|¨Ò: ·Ð½Ð°Ñ¦Ò¤u§@ªí'1033600-2013' AI12Äæ¤ÎAU12Äæ§Úªº¨â¥ú¨ç¼Æ³o»ò¼g: =IF(A12="","",IF(AND(C1='Updated Data'!A2)+AND(A12='Updated Data'!D2)+AND(J12='Updated Data'!M2),'Updated Data'!AL2,"")) ¥i¬O³o©Û¦A¥t¤@±i¤u§@ªí'1006600-2013'´N¤£ÆF¥ú...:L
*èè§Ú¥ÎIndex+match¦n¹³¥i¥HÆF¥ú¤F!
¨Ò¤u§@ªí'1033600-2013' ¡G
AI12Äæ {=IF(A12="","",INDEX('Updated Data'!AL:AL,MATCH($C$1&$A12&$J12,'Updated Data'!A:A&'Updated Data'!D: D&'Updated Data'!M:M,0)))}
AU12Äæ {=IF(A25="","",INDEX('Updated Data'!AX:AX,MATCH($C$1&$A25&$J25,'Updated Data'!A:A&'Updated Data'!D: D&'Updated Data'!M:M,0)))}
¥i¬O¤£ª¾¬°Ô£¤@©w±o¦b³Ì«á«öCtrl+Shift+Enter¤~¯à¶]¥X¼Æ¾Ú,³o¨ç¼Æª½±µ½Æ»s¶KAI13:AI300®É¥þÅÜ'#VALUE!'...
¥H¤W¡A§Æ±æ¦³¸ÑÄÀ²M·¡...
«ô°U...½Ð¶W¯Åª©¥D©âªÅ¤Î¦U¦ì°ª¤â¤j¤j±Ï±Ï§Ú!!
¥®¥®¯Zªº®z¤k¤l¯d:$ |
|