Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

The quartile function does not necessarily return a value that is present in your list of data. So which value do you wish to refer to in this case? The value above or below the quartile number?

I used a range of A1 thru A30. My sample data is as follows:

In cells A1 thru A30 I placed the following values:

1, 3, 3, 13, 13, 13, 13, 13, 14, 34, 34, 43, 46, 46, 51, 51, 51, 57, 61, 75, 134, 215, 345, 346, 346, 461, 571, 1346, 7513, 15761

In cell B1 place the following formula:

=QUARTILE($A$1:$A$30,ROW()

Copy this formula from B1 thru B5 as there are only four quartiles plus the initial value (i.e. =quartile(array,0) thru =quartile(array,4))

Then in cell C1 place the formula:

=VLOOKUP(B1,$A$1:$A$30,1)

Copy this formula from C1 thru C5 to find the value equal to or just below the quartile number for each quartile (0 thru 4).

Note: =quartile(array,0) is the same as =min(array) and =quartile(array,4) is the same as =max(array)

In cell D1 place the following formula:

="A"&MATCH(C1,$A$1:$A$30)

In cell D2 place the following formula:

="A"&MATCH(C1,$A$1:$A$30)+

Copy this formula from D2 thru D5.

This will effectively provide you with the range of the items within the quartile. In my example you will return

A1

A2:A8

A9:A17

A18:A22

A23:A30

Hope this helps.