Pareto of data
 

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?

Pareto of data
 

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

"Dave" wrote:

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?

Pareto of data
 

Thanks, it works and will save me hours.


"bj" wrote:

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

"Dave" wrote:

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?