Hi,

use percentile and this formula gives the first quintile

=PERCENTILE(A1:A20,0.2)

Mike

"vishen" wrote:

I want to find out quintiles in excel sheet (2003 version). Please send me
feedback how to use function for that and what is the method to calculate?

Regards