- ©«¤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 ©ó 2013-2-26 00:31 ½s¿è
¦^´_ 4# Hsieh
A¦¡¡GH2=INDEX($C$2:$C$9,MATCH(1,($A$2:$A$9=MAX(IF($B$2:B$9=G2,$A$2:$A$9,"")))*($B$2:$B$9=G2),0))
B¦¡¡GH2=INDEX($C$2:$C$9,MATCH($G2&MAX(($B$2:$B$9=$G2)*($A$2:$A$9)),$B$2:$B$9&$A$2:$A$9,0))
²¤Æ¤@¤U¡A®t²§¤j·§¬O³o¼Ë¤l¡G
max¨ç¦¡³¡¤À¡G
A¦¡¡Gmax(if(°}¦CA=¥Ø¼Ða,°}¦CB,"")
B¦¡¡Gmax((°}¦CA=¥Ø¼Ða)*(°}¦CB))
B¦¡¤ñ¸ûª½Æ[¡A¦Ó¥B"*"À³¸Ó·|¤ñ"if"¦³®Ä²v¡A©Ò¥HB¦¡§Úı±o¤ñ¸û¦n
match¨ç¦¡³¡¤À¡G
A¦¡¡Gmatch(1,(°}¦CA=¥Ø¼Ða)*(°}¦CB=¥Ø¼Ðb),0)
B¦¡¡Gmatch(¥Ø¼Ða&¥Ø¼Ðb,°}¦CA&°}¦CB,0)
§Úı±oA¦¡¤ñ¸ûª½Æ[¤@ÂI(¤£¹L¨ºÓ"1"nÂà¤@Ó¤pÅs)¡A¦ý¬O´N®Ä²v¨ÓÁ¿¡AB¦¡À³¸Ó·|¦n¤@ÂI(¤j·§·|¸`¬Ùpºâ"°}¦CA=¥Ø¼Ða"©M"°}¦CA=¥Ø¼Ða"ªº®É¶¡§a)
§ï¤Ñ¦A§ï¼g¬Ý¬Ý¡A§Ú²q¤j·§·|¬ÙÓ¤@¥b¦hªº®É¶¡§a¡A¦ý¬OÁÙ¬O«ÜºC(¦½)
¤£¹L¬Ý°_¨Ó³oÓªF¦è¦ü¥G«ÜÃø§ä¥X¤ñO(n^2)ÁÙn§Cªººtºâªk¡K(¸Ü»¡ºtºâªk³oªù½Ò¦b¤W¤°»ò§Ú´X¥G¤w¸g§Ñ¥ú¤F)
·PÁª©¥D~ |
|