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!
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!