이 함수는 Google Sheets에서도 Excel과 동일하게 작동합니다 — 구문과 인수가 같습니다.
SMALL(array, k)The SMALL function is used to identify the value at a specific rank within a range of numbers, where k represents the position from the smallest. It is useful for finding the minimum, second minimum, or any other relative rank in a dataset.
=SMALL({10, 5, 20, 8}, 2)결과: 8
Finds the 2nd smallest value in the set {10, 5, 20, 8}, which is 8.
The function will return a #NUM! error.