Match Index question not displaying unique values?

[Ninjawacker]

Hello

I have a spreadsheet with two columns as the base data. The first column has the amount of times an error has occurred and the second column displays the error description.

So on the data worksheet which holds the error descriptions and number of times that error has occurred in column E is the description and column F is the amount of times it occurs.

I have set up a new worksheet to try and auto sort the top amount from column F on the data sheet which I've used a =LARGE formula in column C that works great and it's sorted the numbers ok and I've set up a formula in column B with a =INDEX MATCH formula to capture the description from the data sheet.

Now this works ok until say at the top I have the numbers 382 in C3 and C4 as there are two different errors associated the same number of times that error has occurred.

How do I get the list to match the number but then display the different descriptions as at the moment is displaying the same description in both rows?

Been trying to fix for hours but no joy.

Any help would be appreciated

Thank you.

 

[Scott T]

Try

Copy the formula in I2 down to cover the max possible returns.

Book1
	E	F	G	H	I
1	number	discription		most errors
2	1	error 146		7	error 23
3	5	error 887			error 581
4	7	error 23			error 780
5	6	error 907
6	2	error 847
7	1	error 602
8	7	error 581
9	4	error 239
10	7	error 780
Sheet4

Cell Formulas
Range	Formula
H2	=LARGE(E2:E10,1)
I2	{=IF(ROWS(I$2:I2)>COUNTIF($E$2:$E$10,$H$2),"",INDEX($F$2:$F$10,SMALL(IF($E$2:$E$10=$H$2,ROW($F$2:$F$10)-ROW($F$2)+1),ROWS(I$2:I2))))}
Press CTRL+SHIFT+ENTER to enter array formulas.