- ©«¤l
- 2025
- ¥DÃD
- 13
- ºëµØ
- 0
- ¿n¤À
- 2053
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- Office2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_¥«
- µù¥U®É¶¡
- 2011-3-2
- ³Ì«áµn¿ý
- 2024-3-14
     
|
¦^´_ 5# landylin
¨Ï¥Î¤½¦¡¬O¤ñ¸û½ÆÂø
¼W¥[¨Ì»²§Uªí¥i¥H²¤Æ¤½¦¡
»Ý¨D¶q¨Ì¥Í²£§å¶q©î¤u³æ¶q-ML089.rar (8.51 KB)
H6 =IF(SUMPRODUCT(($E6=$E$5:$E5)*(0&$H$5:$L5))+SUM($G6:G6)-SUM($G6) >= SUMIF($E$6:$E6,$E6,$F$6),"",MIN(VLOOKUP($E6,$B:$C,2,),SUMIF($E:$E,$E6,$F:$F)-(SUMPRODUCT(($E6=$E$5:$E5)*(0&$H$5:$L5))+SUM($G6:G6)-SUM($G6))))
¥ý¥k©Ô¦A¤U©Ô
¤½¦¡»¡©ú: IF(¶À¦â°Ï>=FÄæ®É, "" , MIN(°ò¥»¶q, ³Ñ¾l¶q))
P5 {=IF(ROW(A1)>COUNT($H$6:$L$12),"",INDEX($E:$E,SMALL(IF($H$6:$L$12<>"",ROW($H$6:$L$12)),ROW(A1))))}
Q6 {=IF(ROW(A1)>COUNT($H$6:$L$12),"",MOD(SMALL(IF($H$6:$L$12<>"",ROW($H$6:$L$12)*10^6+COLUMN($H$6:$L$12)*10^3+$H$6:$L$12),ROW(A1)),10^3))}
R6 {=IF(ROW(A1)>COUNT($H$6:$L$12),"",INDEX($G:$G,SMALL(IF($H$6:$L$12<>"",ROW($H$6:$L$12)),ROW(A1))))}
{....} ¦¹¬°°}¦C¤½¦¡¡A{ }¤£¥Î¿é¤J¡A¬O¥HCTRL+SHIFT+ENTER°ÑÁä»ô«ö¿é¤J¤½¦¡©Ò²£¥Íªº |
|