l****a
发帖数: 86 | 1 for a row of 6 numbers, I need the sum of the largest 4 numbers, how to input
the function? since there are over 150 entries, I can't just add it one by
one. Thank you! | o**n
发帖数: 14 | 2 The following functions may help:
LARGE(array, k): to get the k-th largest value in a data set
SMALL(array, k): to get the k-th smallest value in a data set
Min(): get the minimum
input
【在 l****a 的大作中提到】
: for a row of 6 numbers, I need the sum of the largest 4 numbers, how to input
: the function? since there are over 150 entries, I can't just add it one by
: one. Thank you!
|
|
