Hellow i have a very similar question as the one above,
i have a table that is about size 214*214 cells
It looks like this
R/C B D E F HE
3 Ajd2 Pos2 Bes2 Ger2 Red2 . . . . n
5 Ajd1 1 2 5 3 0……………………………4
6 Pos1 4 3 4 2 1…………………………200
7 Bes1 2 5 1 3 4………………………….30
Ger1 3 …………………………………………………………….1
Red1 5 …………………………………………………………………20
. ………………………………………………………………………
. ………………………………………………………………………
. ………………………………………………………………………
214 n ………………………………………………………………………


i have used aggregate function to extract top x values for a specific criteria.
For example let say I want top x values for Pos1:
I chose Pos1 from a dropdown list in a cell B218 and In cell D218 it gives me number 4 and then in cell E218 again value 4 and so on.
Now the next step is to link those values to names from D3:HE3 in the cell bellow the numbers(D219 for value in D218, E219 for value in E218... )
I manage to do that whit this formula INDEX($D$3:$HE$3;;MATCH(D218;INDEX($D$5:$HE$214;MA TCH($B$218;$B$5:$B$214;0);0);0))
Where this part
INDEX($D$5:$HE$214;MATCH($B$218;$B$5:$B$214;0);0) gives me all the numbers in the row, where Pos1 is located.
The problem that is annoying me is how to change this function that it will return for first number "4" Ajd2 and then for the second "4" Bes2 and not the Ajd2 again. Is it possible to do that without any extra rows or columns?
I can send my workbook if someone needs it to solve the problem 


I have solved it. Thnx any way.