The Excel QUARTILE function returns the quartile (each of four equal groups) for a given set of data. QUARTILE can return minimum value, first quartile, second quartile, third quartile, and max value.
Get the quartile in a data set
Value for requested quartile
=QUARTILE (array, quart)
array - A reference containing data to analyze.
quart - The quartile value to return.
Use the QUARTILE function to get the quartile for a given set of data. QUARTILE takes two arguments, the array containing numeric data to analyze, and quart, indicating which quartile value to return. The QUARTILE function accepts 5 values for the quart argument, as shown the in the table below.
To highlight cells by quartile, you can apply conditional formatting with a formula that uses the QUARTILE function.
In the example shown, we are using 4 different conditional formatting rules. Each rule highlights a...
Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.