Large function, problem with duplicate numbers, and selection of right value

[thelmers]

Hi all,
I would like to select the 10 company´s who have the most errors, and return count off errors and company name as shown in colum e and f.

I´m stuck on this problem, can any one help me with this?

Regards Tommy

[dilipandey]

Hi Tommy,

See the attached file.
Not sure if you need companies name repeated in the list as shown in your example...

Regards,
DILIPandey

<click on below 'star' if this helps>

[Marcol]

@ DILIPandey, I'm not sure that your solution is correct

Try this in F2

=LARGE($B$2:$B$92,ROW($B1))

and this array formula in E2

=INDEX($A$2:$A$92,SMALL(IF($B$2:$B$92=$F2,ROW($A$2:$A$92)-1),COUNTIF($F$2:$F2,$F2)))

Confirm with Ctrl+Shift+Enter not just Enter
Drag/Fill Down

This can then be developed with RANK() to get the required number of returns.

See this workbook, select from the dropdown in D1

[thelmers]

Thanks all for your help, i´m very satisfied with your answers!!

// Regards Tommy