输入以下数组公式,按Ctrl+Shift+Enter组合键结束
=INDEX(C:C,MIN(IF(C1:C100<>"",ROW(1:100))))
或者=INDEX(C:C,SMALL(IF(C1:C100<>"",ROW(1:100),4^8),1))