Forum Discussion
EXcel SUMPRODUCT
=SUMPRODUCT((AGGREGATE(14,4,E2:Z2,ROW($1:$5)))/5) I have been using the above formula successfully to select the 5 largest numbers in a row of 35 numbers There are some 60 rows I now want to amend...
If you have row of numbers like this:
40,38,32,37,38,38,36,38,38,33,34,37,35,31,41,42
Will it select only the first 38 and and the first 37 ignore the other 38's and 37's
to end up like this as the 9 selected
42,41,40,38,37,36,35,34,32
40,38,32,37,38,38,36,38,38,33,34,37,35,31,41,42
Will it select only the first 38 and and the first 37 ignore the other 38's and 37's
to end up like this as the 9 selected
42,41,40,38,37,36,35,34,32
no, this is to select only first occurance of the largest number
- No worries, the formulas I am now using are working fine.
Thanks for your interest
Vic I have checked the post throughoutly and I am sorry I have passed your earlier information.
- I am not quite clear on this.
If the largest number was a 40 and there were three of them, would it only select the first one and ignore the other two even if those numbers made up part of the 9 largest?
