extraction of max values from a range
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 .
|