- ©«¤l
- 678
- ¥DÃD
- 147
- ºëµØ
- 0
- ¿n¤À
- 799
- ÂI¦W
- 0
- §@·~¨t²Î
- win 8
- ³nÅ骩¥»
- MS 2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2016-2-9
- ³Ì«áµn¿ý
- 2022-1-20
|
¥»©«³Ì«á¥Ñ ziv976688 ©ó 2019-9-24 04:21 ½s¿è
¦^´_ 1# ziv976688
1¼Óªº»Ý¨D¥i©¿²¤¤£±j¨D~¤@¦]¥u¬O¦h¼g1ÓAS3ªº¤½¦¡¡C¤]¤£¬O¦h³Â·Ðªº¨Æ¡A¤G¦]¦³§ó«nªº°ÝÃD¨D¸Ñ~
¤¦æªº«e3¤p¤u§@ªíªºAR3
=IF(AQ3=999,"",SUBSTITUTE(TEXT(SUM(LARGE(IF(INDEX($B:$G,AR$1,)=AQ3,$B$2:$G$2,0),{1,2,3,4,5})*10^{0,2,4,6,8}),"00"&REPT("!,00",4)),"00,",))
½Ð°Ý: ¤½¦¡¤¤ªº1,2,3,4,5©M0,2,4,6,8©M4¥Nªí¤°»ò·N¸q?
PS :¤¦æªºÄæ¼Æ¤ñ=6:9:8:8:8
¦p¤U¹Ï :
¦]¬°·í®æ¦¡§ï¬°¦p§À¼Æªº«e3¤p¤u§@ªí¡A¨äAR3¤½¦¡´N¥²¶·§ï¬°
=IF(AQ3=999,"",SUBSTITUTE(TEXT(SUM(LARGE(IF(INDEX($B:$E,AR$1,)=AQ3,$B$2:$E$2,0),{1,2,3})*10^{0,2,4}),"00"&REPT("!,00",4)),"00,",))
¤~¯àÅã¥Ü¥¿½Tªºµª®×¡C
½Ð°Ý: AR3ªº¤½¦¡§ï¦¨³o¼Ë¥¿½T¶Ü?
PS :§À¼ÆªºÄæ¼Æ¤ñ=4:4:4:4:4:4:4:4:4:3
¦p¤U¹Ï :
¦]¬°539ÁÙ¦³
¥Í¨vªºÄæ¦ì¤ñ=3:3:3:3:3:3:3:3:4:4:4:3
¤K¨öªºÄæ¦ì¤ñ=4:5:5:5:5:5:5:5
¥t¥~¤j¼Ö³z49¦³
¤¦æªºÄæ¦ì¤ñ=8:12:10:10:9
§À¼ÆªºÄæ¦ì¤ñ=5:5:5:5:5:5:5:5:5:4
¥Í¨vªºÄæ¦ì¤ñ=4:4:4:4:4:4:4:4:4:4:5:4
¤K¨öªºÄæ¦ì¤ñ=6:6:7:6:6:6:6:6
©Ò¥H½Ð«ü¾É©M»¡©ú¤½¦¡¤¤¦U¬qªº·N²[¡A¥H§Q¤£¤~¯à¦]À³®æ¦¡ªºÅܤƦӶñ¤J¾A·í¥¿½Tªº¤½¦¡¡C
ÁÂÁÂ!
´ú¸ÕÀÉ :
´ú¸ÕÀÉ.rar (42.52 KB)
|
|