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)

Mei Heung

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