请问:如何判断一张表的第几名是一等奖?
=IF(D2<=ROUNDUP(COUNTA($D$2:$D$10)*10%,0),"一等奖",IF(D2<=ROUNDUP(COUNTA($D$2:$D$10)*30%,0),"二等奖",""))
说明,因为10%是范围,通常的做法是进位取整,比如10%为第一名,总数10%不够1名就按1算。
绛旓細璇存槑锛屽洜涓10%鏄寖鍥达紝閫氬父鐨勫仛娉曟槸杩涗綅鍙栨暣锛屾瘮濡10%涓绗竴鍚锛屾绘暟10%涓嶅1鍚灏辨寜1绠椼
绛旓細鍙互鍒╃敤绛涢夛紝涔熷彲浠ラ噰鐢ㄦ暟鎹忚琛紝閫忚鍥
绛旓細鑰屼笁鍙蜂袱娆℃诲垎宸茬粡涓70锛屽氨绠楁渶鍚庝竴娆℃湭涓紙鍙涓嶆墸鍒嗭級锛屼篃鏄涓銆
绛旓細鍦ㄥ綋鍓嶅崟鍏冩牸涓樉绀哄綋鍓嶅伐浣琛ㄥ悕绉扮殑鍑芥暟锛=MID(CELL("Filename"),FIND("]",CELL("Filename"))+1,LEN(CELL("Filename"))-FIND("]",CELL("Filename")))=CELL("Filename")锛屾槸鏄剧ず褰撳墠鏂囦欢鐨勫畬鏁翠繚瀛樿矾寰勶紝鍦ㄤ繚瀛樺悗锛屾墠鏈夊硷紝鍚﹀垯涓洪敊璇笺傚彟鏈変竴娉曪細瀹氫箟涓涓鍚嶇О锛歴h=REPLACE(GET.DOCUM...
绛旓細浣犺繖涓緢楹荤儲銆傞鍏堬紝绗涓寮犺〃a鍒楁槸鎺掑悕鐨勪緷鎹--鏁板笺俠鍒椾綔涓烘帓鍚嶃傜劧鍚巆鍒楁槸寰楀垎 浣犻渶瑕佸湪鍙︿竴寮犺〃锛堜緥濡俿heet2锛変腑銆傚仛涓涓鍚嶈〃銆俛鍒楁槸鎺掑悕锛宐鍒楁槸鎺掑悕鎵瀵瑰簲鐨勫緱鍒嗐傝繖涓〃鍙互鎵嬪伐鍘诲仛銆備篃鍙互鐢ㄥ叕寮 b7=b6-2锛宐16=b15-2銆傝繑鍥炵涓寮犺〃锛屽亣璁炬湁鏍囬琛屻傚湪b2涓緭鍏ュ叕寮 =SUMPRODUCT((...
绛旓細鍋囪Sheet1鍜孲heet2琛ㄧ殑A鍒楁槸濮撳悕锛屽垯鍦⊿heet2琛ㄧ殑B1杈撳叆涓嬮潰鐨勫叕寮忥細=Match(A1,Sheet1!A:A,0)鍏紡涓嬫媺澶嶅埗銆傜粨鏋滆繑鍥炴暟瀛楃殑锛屽垯璇ユ暟瀛楄〃绀篠heet1琛ㄧ殑A鍒绗嚑琛屾槸璇ュ悕瀛楋紝濡傛灉杩斿洖閿欒鍊#N/A锛屽垯琛ㄧずSheet1琛ㄧ殑A鍒楁病鏈夎濮撳悕銆
绛旓細1銆佹墦寮涓涓EXCEL鏂囦欢锛屽彲浠ョ湅鍒板綋鍓嶆湁Sheet1鍜孲heet2锛屼袱涓暟鎹2銆佺浜屽紶鏁版嵁琛ㄦ暟鎹涓嬨3銆佹鏃堕渶瑕佹煡鎵惧嚭琛1鐨鏁版嵁鏄惁鍦ㄨ〃2涓紝鍒囨崲鍒拌〃1锛屽湪瀵瑰簲鐨勫崟鍏冩牸涓緭鍏F(COUNTIF)銆4銆佸啀杈撳叆灏忔嫭鍙枫5銆佸皢榧犳爣绉诲姩鍒拌灏忔嫭鍙峰唴銆6銆佸啀鐐瑰嚮琛2銆7銆佸湪鍑虹幇鐨勮〃2鐣岄潰涓変腑鎵鏈夊崟鍏冩牸鐨勬暟鎹8...
绛旓細1銆侀鍏堬紝闇瑕佸皢瑕佹煡鎵炬暟鎹殑鎵鏈夊崟鍏冩牸閫変腑锛屾帴鐫渚濇鍦ㄥ伐鍏锋爮鎵惧埌"寮濮"-"鏍峰紡"锛2銆佸湪鏍峰紡閲岀偣鍑"鏉′欢鏍煎紡"锛岀劧鍚庢帴鐫閫夋嫨"绐佸嚭鏄剧ず鍗曞厓鏍艰鍒"-"閲嶅鍊"锛屽涓嬪浘鎵绀猴紱3銆佺劧鍚庝細寮瑰嚭閲嶅鍊煎璇濇锛屾垜浠彲浠ヨ嚜鐢辫缃竴绉嶆爣娉ㄦ柟寮忥紝姣斿璇存湁涓嶅悓棰滆壊鐨勬枃鏈拰涓嶅悓棰滆壊鐨勮竟妗嗘樉绀烘柟寮忋4銆佹垜浠篃...
绛旓細Oracle 涓 cols绯荤粺琛ㄤ腑鏄瓨鏀琛ㄧ殑瀛楁淇℃伅鐨勶紝TABLE_NAME瀛楁鏄綋鍓嶇殑琛ㄥ悕锛孋OLUMN_NAME鏄綋鍓嶇殑瀛楁鍚,column_id鏄涓涓瀛楁锛1鑷劧鏄綘鎯宠鐨勭粨鏋滀簡锛岃繕鏈夊氨鏄〃鍚嶄竴瀹氳杈撳叆澶у啓鐨勶紒
绛旓細鍦ㄥ彟澶栦竴鍒楀唴杈撳叆:=if(countif(a:a,a1)=2,"閲嶅椤",""),鐒跺悗澶嶅埗绮樿创鍒版暣鍒,鍙鏄湁閲嶅椤,閭d釜鍗曞厓鏍煎氨浼氭樉绀"閲嶅椤"瀛楁牱,鐒跺悗鍙绛涢夊嚭鎵鏈"閲嶅椤"鍗冲彲.