View Full Version : Return top 5 From a tabel of data

06-01-2008, 06:11 AM
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
06-01-2008, 06:52 AM
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.