- ©«¤l
- 186
- ¥DÃD
- 6
- ºëµØ
- 0
- ¿n¤À
- 218
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-11-12
- ³Ì«áµn¿ý
- 2014-4-15
|
¦^´_ Bodhidharma
±ø¥ó¶V¦h´N¶V³Â·Ð¡A»²§UÄæ¦ì´Nn¼W¥[
Hsieh µoªí©ó 2013-4-4 00:07
¶V¬Ý¶V¤£À´¡KÁöµM¦h¤F´XÓ»²§UÄæ¡A¦ý¬Oµ²ªG¦ü¥G©M§A쥻ªºª©¥»¤£·|¦³®t²§
1 0
2 3
2 0
3 3
3 0
4 0
1 0
0 0
ªº²{¶HÁÙ¬O¦s¦b°Ú
¤£¹L§Úı±o¸ò¥»ªº°ÝÃD¬O¥X²{ìpo¨S¦³Á¿²M·¡¦pªG¦³«½Æªº"²³¼Æ"n«ç»ò³B²z
¥uÅã¥Ü²Ä¤@Ó¡G¥Î§Úì©lªºÀÉ®×
¨âÓ³£Åã¥Ü¡GC2Àx¦s®æ=IF(D2=MAX(OFFSET(INDEX(A:A,MATCH(A2,A:A,0),),,3,COUNTIF(A:A,A2),)),B2,0)
¥uÅã¥Ü³Ì«á¤@Ó¡GHsiehªº²Ä¤GÓ»²§UÄæ¥[§Úì©lªºÀÉ®×
¥H¤Î§Ú«e±°Ýªº¡G
0
1
1
2
2
2
2
3
3
1
1
1
1
0
³o¼Ë¬On¼Ð2(³Ì¦¥X²{ªº"³sÄò¥X²{³Ì¤jÈ")ÁÙ¬On¼Ð«á±ªº1(Á`¦@¥X²{³Ì¦h)? |
|