Basic Functions: LARGE, SMALL

SMALL returns the kth smallest value in a range of cells, LARGE returns the kth largest value in a range of cells.



In the example below, we see how the SMALL and LARGE functions repectively retrieve values based on their ranks in the selected range of cells.

largesmall.jpg

Leave a Reply