Dynamic range inside array formula with use of match

Dear Friends,

I've am array formula that I use to provide highest values:

Please Login or Register  to view this content.

I want to replace the range Data!$D$2:$D$128 with a dynamic reference: like that one:

Please Login or Register  to view this content.

What I'm trying to achieve is to build a spreadsheet that would look up the 10 highest and ten lowest values within category (example). So first I want to the formula to consider only values in the category A and secondly only the values that are in column that is of interest. The attached example has only one - value but in practice there will be more. This is why the data range have to by dynamic. The numbers 2 and 128 have to reflect first and last row of the category that is of interest. The latter D have to reflect the column that is being considered.

P.S.
As this was quite important to me I posted the same post here
http://www.ozgrid.com/forum/showthread.php?t=167461

I'm afraid your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

Hi konradz.

@jeff - because this is a simple answer and the other cross post will most likely not get an answer, I appologize for answering it here. Perhaps konradz will trust our members with his question more in the future?

The answer is hidden in Pivot Tables. In a pivot table you can filter by Category and in the Rows only show the top 10 or 3 as in my example. See the attached to see what I did. Then study Pivot tables to understand their power.