請問一下有冇一條式可以計一堆數既第2高分同3高分?
例如:1,2,3,4,5
我想搵第2高分同第3高分..姐係4同3
應該點搵?
excel公式一問..請問一下有冇一條式可以計一堆數既第2同第3高分?
2008-01-30 7:38 am
回答 (2)
2008-01-30 8:02 am
✔ 最佳答案
=LARGE(A1:A100,1) →最高分=LARGE(A1:A100,2) →第2高分
=LARGE(A1:A100,3) →第3高分
2008-01-30 8:03 am
Assume
Cell A1 = 1
Cell A2 = 2
Cell A3 = 3
Cell A4 = 4
Cell A5 = 5
Put this formula in Cell B1
=LARGE(A1:A5, 2)
will give you the 2nd highest score
................................................
If you put this formula
=LARGE(A1:A5, 3)
will give you the 3rd highest score
Cell A1 = 1
Cell A2 = 2
Cell A3 = 3
Cell A4 = 4
Cell A5 = 5
Put this formula in Cell B1
=LARGE(A1:A5, 2)
will give you the 2nd highest score
................................................
If you put this formula
=LARGE(A1:A5, 3)
will give you the 3rd highest score
參考: myself
收錄日期: 2021-04-16 12:16:20
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20080129000051KK03742