- Picture and text skills
- Case
Returns the k-th smallest value in the data set. Use this function to return a numeric value at a specific position in a data set.
Syntax
SMALL(array,k)
Array is the array or numeric data area where the k-th minimum value needs to be found.
K is the returned data in the array or data Location in the area (from smallest to largest).
Description
• If array is empty, function SMALL returns the error value #NUM!.
• If k ≤ 0 or k exceeds If the number of data points is exceeded, function SMALL returns the error value #NUM!.
• If n is the data in the array The number of points, then SMALL(array,1) is equal to the minimum value, and SMALL(array,n) is equal to the maximum value.
Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/qiao-yong-SMALL-han-shu-cha-zhao-shu-ju-ji-de-zui-xiao-zhi.html
支付宝扫一扫 
评论列表（196条）
测试