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

±N­ì¨Ó¦¸§Ç­«·s±Æ¦C,¨D¬ÛÃö¤½¦¡ªº¦ù©µ°ÝÃD

±N­ì¨Ó¦¸§Ç­«·s±Æ¦C,¨D¬ÛÃö¤½¦¡ªº¦ù©µ°ÝÃD

¥»©«³Ì«á¥Ñ K_Wing ©ó 2014-12-21 17:29 ½s¿è

AB
C
D
E
1 001
$1527.00 11
2 002
$8542.10 2
3 003
$8971.50 1
4 004
$4588.70 7
5 005
$1651.50 10
6 006
$7500.00 4
7 007
$8512.30 3
8 008
$4588.10 8
9 009
$6579.80 6
10 010
$6587.00 5
11 011
$3444.80 9


¦p¤W¹Ï¡G
A¦C¬O¤@°ï¤½¥q¦WºÙ(©T©w¦ì¸m,¤£¥Î²z·|)
B¦C¬O¤W¤ëªº¦¸§Ç
C¦C¬O±q¨ä¥L¦a¤è¿é¤J¡A¦b³o¦C¤¤¤£Â_²Ö¿nªºÁ`¼Æ
D¦CÅã¥ÜC¦C§ó·s«áªº³Ì·s±Æ§Ç

°ÝÃD¡G
·Q¦bE¦C¥Î¤½¦¡­pºâ¥X»P³Ì¤jªº±Æ¦W
¬Û¶Z¦h¤Ö
(°²³]²{¦³±Æ¦W¬O4,»P²Ä¤@¦ì¬Û¶Z¬O3)
©Î¬O¬Û¶Zª÷ÃB¦h¤Ö
(°²³]²{®Éªºª÷ÃB¬O$7500.00,»P³Ì¤jªºª÷ÃB$8971.50,»Ý­n­pºâ¥X¬Û®t­È$1471.50)

¦^´_ 1# K_Wing


    E1=MAX($C$1:$C$11)-C1, ¤U©Ô

TOP

¦^´_  K_Wing


    E1=MAX($C$1C$11)-C1, ¤U©Ô
samwang µoªí©ó 2014-12-21 19:58

·PÁÂ¥S§Ì¥X¤â¬Û§U
¤w¸Õ¹L¦³Ãö¤½¦¡
¦P¨Æ­Ìı±o§ï¬° E1=M¢×¢Ü($C$1:$C$11)-C1, ¤U©Ô
·|¤ñ¸û¦n
¦hÁÂ¥S§Ìµ¹»P±Òµo
ÁÂÁÂ

¥t·Q°Ý°Ý
­Y·Q§ï¬°²Ä¤@±Æ¦W»P²Ä¤T±Æ¦W¸m¤ñ¸û
¥i¥H«ç¼Ë­×§ï©O¡H

TOP

¦^´_ 3# K_Wing

¥t·Q°Ý°Ý
­Y·Q§ï¬°²Ä¤@±Æ¦W»P²Ä¤T±Æ¦W¸m¤ñ¸û
>> §Ú¤ÓÀ´§Aªº·N«ä¡A¥i¥H¦A¸Ñ»¡¸Ô²Ó©Îªþ¥óÀÉ®×

TOP

¦^´_ 3# K_Wing
­Y«ü©w²Ä¤@±Æ¦W©Î²Ä¤T±Æ¦Wµ¥ª¬ªp¤ñ¸û¡A«Øij¨Ï¥Î
SMALL(array,k) ©Î LARGE(array,k)³B²z
½Ð°Ñ¦Ò¡I

TOP

¦^´_  K_Wing

¥t·Q°Ý°Ý
­Y·Q§ï¬°²Ä¤@±Æ¦W»P²Ä¤T±Æ¦W¸m¤ñ¸û
>> §Ú¤ÓÀ´§Aªº·N«ä¡A¥i¥H¦A¸Ñ»¡¸Ô²Ó©Îªþ¥ó ...
samwang µoªí©ó 2014-12-21 21:52

¦]C¦Cªº¼Æ¦r¤£Â_§ïÅÜ
¦ÑÁó·Q¬Ý¬Ý¤£Â_§ïÅܪº¼Æ¦r¤¤
²Ä¤T±Æ¦W»P²Ä¤@±Æ¦WªºÁ`¼Æ
¬Û®t¦h¤Ö
¥Ñ©ó¼Æ¦r¤£Â_§ïÅܤ¤
¦bC¦C¤¤©w¦ì­pºâ¦³§xÃø
©Ò¥H·Q¥æ¥Ñ¤½¦¡¨Ó¦Û°Ê­pºâ

TOP

¦^´_  K_Wing
­Y«ü©w²Ä¤@±Æ¦W©Î²Ä¤T±Æ¦Wµ¥ª¬ªp¤ñ¸û¡A«Øij¨Ï¥Î
SMALL(array,k) ©Î LARGE(array,k)³B²z
½Ð ...
p212 µoªí©ó 2014-12-22 11:19

¦hÁÂ¥S§Ì´£¨Ñ¤½¦¡
¦]C¦C¤¤ªº¦U¶µ¼Æ¦r
·|¥Ñ¨ä¥L¦a¤è¿é¤J¨Ã¼Wªø
¤Þª´±Æ¦W·|ÀH®É§ïÅÜ
©Ò¥H¤½¦¡¤£¯à©T©w©ó¤@­ÓÀx¦s®æ

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2014-12-22 15:46 ½s¿è

¦^´_ 7# K_Wing
¥i¥H´£¨Ñ½d¨ÒÀÉ (¤º§t´Á±æªºµª®×¡A¦p¼Ë¦¡¬°¼Æ¦r©Î¤å¦r¡B¥X²{ªº¦ì¸m¬°ªíÀY©Î»P­ì¸ê®Æ¬Û¹ï¦ì¸m...)¡H
¬Ù¥h¦P¦n­Ì³yÀɪº³Â·Ð¡AÁÂÁ¡I

TOP

¦^´_ 8# p212
C¦Cªº¼Æ¾Ú¥Ñ¨ä¥L¦a¤è¶Ç¹L¨Ó¼Wªø
¦]¬O¤½¥qªºÀÉ®×
¤£«K¤W¶Ç¤W¨Ó
¥t°µ¤@­ÓÀÉ®×
«K¤£·|¥X²{¼Æ¾Ú¼Wªø
¥u¯à§@¬°°Ñ¦Ò
¨Ò¤l¦p¤U¡G
A
B
C
D
E
1
¤½¥q¦WºÙ
¤W¤ë±Æ¦W²{¦b²Ö¿n
¤µ¤ë±Æ¦W
²Ä¤T¦W»P²Ä¤@¦W¬Û¶Z
2
¤A¤½¥q
01$200.00
04
(¤£¥ÎÅã¥Ü,°£«D²Ö¿n¨ì²Ä¤T¦W®É¤~ÅV¥Ü)
3
¤þ¤½¥q
02
$456.00
03
(¥u»ÝÅã¥Ü»P²Ä¤@¦W¬Û¶Z±Æ¦W)-2 ©Î -$294.00(©ÎÅã¥Ü²{ª÷¬Û¶Z)
4
¤B¤½¥q
03
$500.00
02
(¤£¥ÎÅã¥Ü,°£«D²Ö¿n¨ì²Ä¤T¦W®É¤~ÅV¥Ü)
5
¥³¤½¥q
04
$750.00
01
(¤£¥ÎÅã¥Ü,°£«D²Ö¿n¨ì²Ä¤T¦W®É¤~ÅV¥Ü)

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2014-12-23 08:44 ½s¿è

¦^´_ 9# K_Wing
Àx¦s®æE2¿é¤J
=IF(C2=LARGE(OFFSET($C$2,,,COUNTA(C:C)-1),3),C2-LARGE(OFFSET($C$2,,,COUNTA(C:C)-1),1),"")
¦V¤U½Æ»s¤½¦¡
½Ð°Ñ¦Ò¡I
ps. ¡u´£¨Ñ½d¨ÒÀÉ¡vªº·N«ä¬°¤W¶ÇExcel®æ¦¡ªºªþ¥ó¡A¦Ó«D¶K¹Ï¡F¤£«K¤W¶Ç­ìÀɮɡA¥i³y¼ÒÀÀÀɧY¥i¡C

TOP

        ÀR«ä¦Û¦b : ¤â¤ß¦V¤U¬O§U¤H¡A¤â¤ß¦V¤W¬O¨D¤H¡F§U¤H§Ö¼Ö¡A¨D¤Hµh­W¡C
ªð¦^¦Cªí ¤W¤@¥DÃD