« Basic functions : REPLACE, SUBSTITUTE | Main | Date & Time : Calculating the end-of-month »
October 25, 2004
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.
Posted by Dave at October 25, 2004 04:41 AM