sorting data -few questions. How do I...?

[Toddcan]

I have about 20 columns contains array formulea, and pretty complicated "stuff". There are also about 250 rows (representing different scenerios).

My last column provides me with the magical number I am looking for. I want to know the top 5, 10, or whatever numbers (lowest, highest, etc). Of course, since there are over 250 rows, I just can't inspect for the lowest 5 (for example).

Here are the problems I have run into while trying to find the top values.

1. I can run a min(range), but that only gives me 1 number, and I don't know which row it came from -how do I do that?

2. I tried to sort my whole table based on my final column, but it didn't work. It gave me a worksheet FULL of +Value? and #### errors (remember, my worksheet is full of array functions).

How can I make a table of the lowest 5 numbers, and identify which rows they came from?

Thanks!

 

[Mark W.]

Have you considered using an Autofilter? It supports the display of Top/Bottom x items in a data list.

 

[Toddcan]

PERFECT!!! Thanks!