Skip to main content
Hudl

SMALL

Finds the nth smallest value in the cell group.

FORMAT: SMALL ( reference ..reference RANKED ranking )

DEFINITIONS:

  • reference: column number or column title, row number or quoted text representing a cell title
  • ranking: a number representing the nth smallest value, 1 being the smallest

EXAMPLE 1:

small (2,1..4,3 ranked 2)

Returns the 2nd smallest value of all cells between column 2, row 1 and column 4, row 3

EXAMPLE 2:

small ("cell".."cell2" ranked 1)

Returns the smallest value from all cells between cells with titles "cell1" and "cell2"

EXAMPLE 3:

small (2,3.."column1",4 ranked 3 )

Returns the 3rd smallest value of all cells between column 2, row 1 and the column with the title "column1" on row 4

EXAMPLE 4:

small ($column+1,$row..$column+2,$row+1 ranked 1)

Returns the smallest value of all cells 1 column right of current cell to 2 columns right, 1 row down