For the largest n:

=LARGE(B$1:B$20,ROWS($1:1)

If you want the 10 largest values then just copy the formula down 10 rows.

For the largest n based on a condition:

Array entered:

=LARGE(IF(A$1:A$20="A",B$1:B$20),ROWS($1:1))

If you want the 10 largest values then just copy the formula down 10 rows.
If there aren't 10 values that meet the condition you'll get #NUM! errors.

Biff

"TUNGANA KURMA RAJU" wrote in
message ...
I have two questions:
1. how to extract 5 or 10 maximum(bigger) values from a column range ?
2.how to extract 5 or 10 maximum (bigger) values from a column range
basing
on another column criteria, say in col A-contaings group code A,B,C....in
col
B- the values.I need 10 maximum values of group B in col C .