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

»Ý­n±N¦P¤@¤H¦³¼Æµ§¸ê®Æ¥u¨ú¨ä¤¤¤@µ§¸ê®Æ­Èªº¤èªk

»Ý­n±N¦P¤@¤H¦³¼Æµ§¸ê®Æ¥u¨ú¨ä¤¤¤@µ§¸ê®Æ­Èªº¤èªk

¨Ò¦p¡G
  ©m¦W ¶µ¥Ø ª÷ÃB
1.±i¤T Á~¸ê   50000
2.±i¤T ¥[¯Z¶O 10000
3.±i¤T ¼úª÷    2000
4.§õ¥| Á~¸ê   40000
5.§õ¥| ¥[¯Z¶O 20000
6.§õ¥| ¼úª÷    1000

µ²ªG·Q­n
¿é¤J©m¦W:§õ¥|¡A¦Û°ÊÅã¥Ü
¥[¯Z¶O 20000
¼úª÷    1000
Á~¸ê   40000

¦ý¬O§Æ±æ¨Ï¥Î¤½¦¡¤£­n¥Îµ{¦¡¡A¦³¨S¦³¤H·|©O¡H

F4 ¸Ìªº"°}¦C¤½¦¡" =INDEX(B$2:B$7,SMALL(IF($A$2:$A$7=$G$2,ROW($B$2:$B$7)-ROW($B$1)),ROWS($E$4:$E4)))

©¹¥k©¹¤U½Æ»s§Y¥i

TOP

¦hÁ¤F,·Q¤F«Ü¤[¹ê¦b·Q¤£¥X¨Ó
µ{«×¨S¨º»ò¦n!

TOP

¦A½Ð±Ð¤@¤U¡G
ROW($B$2:$B$7)-ROW($B$1)¬O¤°»ò·N«ä¡H
ROWS($E$4:$E4)¤S¬O¤°»ò¥Î·N¡H

ÁÙ¦³©ì¦²«áF5-G7³£Åã¥Ü¿ù»~!

TOP

¥»©«³Ì«á¥Ñ handmuch ©ó 2011-4-7 21:43 ½s¿è

¦^´_ 4# tatsun


    §AÀ³¸Ó¬O¨S¦³«öCtrl+shift+Enter¡A³o¬O°}¦C¤½¦¡®@!!

¤£µMvlookup ¤]¥i¥H¥Î¡A¥u¤£¹L­n¼W¥[»²§UÄæ¡CA2ªº¤½¦¡=B2&C2
G4,G5,G6 ¦Û¤v¥´©Î½Æ»s¤W¥h¡AH4¤½¦¡=VLOOKUP($H$2&G4,$A$2:$D$7,4,0)¦A¦V¤U©Ô

TOP

¥ÎVLOOKUP¤½¦¡§Ú´N²M·¡¤F
¤£ª¾¹DVLOOKUP¤½¦¡ÁÙ¥i¥H¥Î$H$2&G4
¤S¦h¾Ç¤F¤@¼Ë

ÁÂÁÂ!

TOP

c.gif

TOP

¦^´_ 6# tatsun


    test.gif
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

[i=s] ¥»©«³Ì«á¥Ñ yanto913 ©ó 2011-4-9 23:12 ½s¿è [/i]

¦^´_ 8# Hsieh

    ³ø§iªO¤j§ÚµLªk¶×¤J¥~³¡¸ê®Æ­C!!

¥¼©R¦W.jpg (11.3 KB)

¥¼©R¦W.jpg

YOYO

TOP

¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¡i°±º¢¤£«e¡A²×µL©Ò±o¡j¤H³£°g©ó´M§ä©_ÂÝ¡A¦]¦Ó°±º¢¤£«e¡FÁa¨Ï®É¶¡¦A¦h¡B¸ô¦Aªø¡A¤]¤FµL¥Î³B¡A²×µL©Ò±o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD