Dave Bruns

The RANK function returns the rank of a numeric value compared to a list of other numeric values. RANK can rank values from largest to smallest (i.e., the rank of highest test scores) and smallest to largest (i.e., the rank of fastest times in a race). You can use the RANK function to...Read more

The SMALL function returns a numeric value based on its position in a list when sorted by value in ascending order. In other words, SMALL can return the "nth smallest" value (1st smallest value, 2nd smallest value, 3rd smallest value, etc.) from a set of numeric data.

The SMALL...Read more

The REPLACE function replaces text at a specific location inside a text string. The location of the text to replace is given as a number representing the first character to replace, along with a character count to indicate how many...Read more