how to find First, Second and Third number in Excel

👨🏻‍🏫 學術台數學

2008-07-03 9:08 am

=max(A1:D4) can be use to list out the max number in the range A1:A4.
How can we find out the 2nd , 3rd Largest number?

更新1:

Excel Function

回答 (2)

2008-07-03 10:05 pm

✔ 最佳答案

=LARGE(A1:A4,1)→1ST(MAX)
=LARGE(A1:A4,2)→2ND
=LARGE(A1:A4,3)→3RD
=LARGE(A1:A4,4)→4TH

👍 0 👎 0

2008-07-03 9:17 am

你打 =max(A1:D4) 時第一個係最大個個, 而在第二.三..四..如此類推已經排好大小了

或是你可以按「排序」(在電腦上角)

參考: myself

👍 0 👎 0

收錄日期: 2021-04-18 17:35:30
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20080703000051KK00138

檢視 Wayback Machine 備份