- ©«¤l
- 315
- ¥DÃD
- 51
- ºëµØ
- 0
- ¿n¤À
- 367
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-9-29
- ³Ì«áµn¿ý
- 2021-10-12
|
¦^´_ 8# ã´£³¡ªL
ã¤j:
¤£¦n·N«ä~¤U¦Cªº¶Q2Ӹѵª¤½¦¡~
=IF(SUMPRODUCT(SUMIF(OFFSET($I$6,$R7+T$3,1,,7),OFFSET($I$6,$R7,1,,7)*(SUMIF(OFFSET($I$6,$R7,1,,7),OFFSET($I$6,T$5,1,,7))>0))),$R7+T$3,"")
=IF(SUMPRODUCT(SUMIF(OFFSET($I$6,$R7+T$3,1,,7),OFFSET($I$6,$R7,1,,7)*(RANK(OFFSET($I$6,T$5,1,,7),OFFSET($I$6,$R7,1,,7))>0))),$R7+T$3,"")
n¦p¦ó±N¨ä¤¤Åã¥Ü©ó$R7+T$3ªºJ¡JP¥ô¤@Àx¦s®æ¤§±ø¥ó~
§ï¦¨
Åã¥Ü©ó$R7+T$3ªºJ¡JP¤§¦PÄæ¦ìÀx¦s®æ¡C
ÁÂÁ±z^^ |
|