Excel quintuple formula?

[BigDelGooner]

Hi guys

Bit stuck here. I have a data set of around 80'ish numbers and would like to split them into a rank of 1 to 5.

If the rank was from 1 to 4 it would be easy because I could use the QUARTILE formula...but what about 1 to 5? As far as I can see there is not a QUINTILE formula?

Any ideas?

 

[shg]

=percentile(A1:A10, 1/5) is the first quintile.

 

[BigDelGooner]

Excellent - thank you.

Its always such a simple solution. I blame it on the time here...18:40!

Thanks again.

 

[shg]

You're welcome, glad it helped.