The RANK.EQ function returns the rank of a numeric value compared to a list of other numeric values. RANK.EQ 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.EQ function...Read more
The RANK.AVG function returns the rank of a numeric value compared to a list of other numeric values. RANK.AVG 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). When RANK.AVG encounters...Read more
The Excel HARMEAN function returns the harmonic mean for a set of numeric values. The harmonic mean is a kind of numeric average, calculated by dividing the number values in a list by the sum of the reciprocal of each value. In other words, the harmonic mean is the reciprocal of the average of...Read more
The Excel GEOMEAN function calculates the geometric mean. Geometric mean is the average of a set of products — technically, the nth root of n numbers. The general formula for the geometric mean of n numbers is the nth root of their...Read more
The Excel TRIMMEAN function calculates mean (average) while excluding outliers. The number of data points to exclude is provided as a percentage.
TRIMMEAN works by first excluding values from the top and bottom of a data set, then calculating mean. The number of data points is provided...Read more
The Excel FLOOR.PRECISE function rounds a number down to a given multiple, where multiple is provided as the significance argument. If the number is already an exact multiple, no rounding occurs and the original number is returned.
The FLOOR.PRECISE function takes two ...Read more
The Excel CEILING.PRECISE function rounds a number up to a given multiple, where multiple is provided as the significance argument. If the number is already an exact multiple, no rounding occurs and the original number is returned.
The CEILING.PRECISE function takes two ...Read more
In this example, the goal is to retrieve information about the lowest three estimates in the data shown. The problem is that there are some duplicate values in the estimate column. This means we will have some trouble trying to display the names of the 2nd and 3rd lowest suppliers because the...Read more
