georgiboy
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.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.