Return top 5 From a tabel of data

[georgiboy]

Hi all

i would like to return a top list 5 from a table of data based on a criteria in this case "Code".

Test sheet attachted

[Bob Phillips]

H4: =LARGE(IF($A$2:$A$25="ADJ",$B$2:$B$25),ROW(A1))

and copy down.

which is an array formula, it should be committed with Ctrl-Shift-Enter, not just Enter.Excel will automatically enclose the formula in braces (curly brackets), do not try to do this manually.When editing the formula, it must again be array-entered.