MIN, MAX, LARGE and SMALL Find the minimum of a range: =MIN(data) Find the $k$ smallest value in a range: =SMALL(data,k) Find the maximum of a range: =MAX(data) Find the $k$ largest value in a range: =LARGE(data, k) Demo