浠婂ぉ閿呯洊澶存潵涓哄ぇ瀹惰В绛斾互涓婇棶棰橈紝excel涓璴arge鍑芥暟鏄粈涔堟剰鎬濓紝excel閲宭arge鍑芥暟鏄粈涔堝緢澶氫汉杩樹笉鐭ラ亾锛岀幇鍦ㄨ鎴戜滑涓€璧锋潵鐪嬬湅鍚э紒

LARGE鍑芥暟鐢ㄤ簬杩斿洖涓€缁勬暟鎹腑鐨勭K涓渶澶у€笺€傚畠鐨勮娉曠粨鏋勬槸=LARGE(鍗曞厓鏍煎尯鍩熸垨鏁扮粍锛孠)鍑芥暟浣跨敤娉ㄦ剰瑕佺偣锛?/p>

1銆佹鍑芥暟璁＄畻鏈€澶у€兼椂蹇界暐閫昏緫鍊间互鍙婃枃鏈瀷鏁板瓧

(资料图片仅供参考)

2銆佺涓€鍙傛暟涓嶈兘涓虹┖锛屽惁鍒欒繑鍥為敊璇€?/p>

3銆佸鏋?k 鈮?0 鎴?k 澶т簬鏁版嵁鐨勪釜鏁帮紝鍒欒繑鍥為敊璇€?nbsp

4銆佸綋K涓嶄负鏁存暟鏃讹紝璁＄畻鏃朵細鎴熬鍙栨暣銆傛瘮濡俴涓?.55鏃讹紝璁＄畻鍙栨暣涓?銆?/p>

excel閲宭arge鍑芥暟鏄粈涔?p>

Excel 涓?LARGE 鍑芥暟鏄繑鍥炴暟鎹泦涓 k 涓渶澶у€笺€?鍙互浣跨敤姝ゅ姛鑳芥牴鎹叾鐩稿浣嶇疆閫夋嫨涓€涓€笺€?渚嬪锛屼娇鐢?LARGE 杩斿洖鏈€楂樸€佺浜屾垨绗笁鐨勫垎鏁般€?/p>

璇硶

LARGE(array锛宬)

LARGE 鍑芥暟璇硶鍏锋湁涓嬪垪鍙傛暟锛?/p>

Array 蹇呴渶銆?闇€瑕佺‘瀹氱 k 涓渶澶у€肩殑鏁扮粍鎴栨暟鎹尯鍩熴€?/p>

K 蹇呴渶銆?杩斿洖鍊煎湪鏁扮粍鎴栨暟鎹崟鍏冩牸鍖哄煙涓殑浣嶇疆锛堜粠澶у埌灏忔帓锛夈€?/p>

鏈枃鍒版缁撴潫锛屽笇鏈涘澶у鏈夋墍甯姪銆?/p>