Pareto of data

D

Dave

I have a columns of data (aprox 150 rows and 30 columns_). I want to extract
the top 12 values of each column in descending order. At the moment I am am
RANKing each column and then doing a HLOOHUP, it is very long winded and
making the file very big.

Any suggestions?
 
B

bj

look at the large() function in help
for example
=large(D$20:D$400,3)
would show the third highest value in the data set D20:D400
 
D

Dave

Thanks, it works and will save me hours.


bj said:
look at the large() function in help
for example
=large(D$20:D$400,3)
would show the third highest value in the data set D20:D400
Click to expand...
 
Top