Index match large problem

[ebea]

Hi! I run into problems, to get get the highest values in a range, listed correctly. The code I use, are originally grabbed from: Index Match Duplicate Values With No Helper Cells [SOLVED]

I have changed the code, delivered from T. Valko (in the Link) a bit, to fit into my use. But when I try to list the highest values, I do only get the value listed as they comes from the match, and not the highest values, as they should be.
I put in here, the example, below!
I only need the 6 highest values.

Do anyone have an idea, how to correct this?
Thank you!

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	200	200	198	200	200	200	200	200	199	199	198	200	200	200	199	199
2	15	11	15	12	12	15	10	16	12	11	9	11	10	18	17	14
3
4	Large 1	Large 2	Large 3	Large 4	Large 5	large 6
5	15	11	12	12	15	10	<---------	Formula result
6
7	18	16	15	15	12	12	<---------	Should be
Sheet1

Cell Formulas
Range	Formula
A5:F5	A5	{=INDEX($A2:$P2,MATCH(LARGE($A1:$P1-COLUMN($A1:$P1)/10^10,COLUMNS($A5:A5)),$A1:$P1-COLUMN($A1:$P1)/10^10,0))}
Press CTRL+SHIFT+ENTER to enter array formulas surrounded with curly braces.

 

[Fluff]

Ok, I understand what you are trying to do, but unfortunately that is beyond my meagre knowledge of formulae.

 

[Fluff]

Ok, bit of a bodge, but it seems to work

=AGGREGATE(14,6,$A2:$P2/($A1:$P1=LARGE($A1:$P1,COLUMNS($R2:R2))),IF(COLUMNS($R2:R2)<=COUNTIF($A1:$P1,LARGE($A1:$P1,1)),COLUMNS($R2:R2),COLUMNS($R2:R2)-COUNTIF($A1:$P1,">"&LARGE($A1:$P1,COLUMNS($R2:R2)))))

 

[ebea]

Hi Fluff! I do not know, in which part of your brain, you did pick that solution out; But I'm impressed. It works, and it's very nice. So a great thanks from me, and that you did'n gave up

 

[Fluff]

Glad to help & thanks for the feedback