EXcel SUMPRODUCT

[Vicphuket]

=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 the formula to select the 9 largest numbers in a row

I then use conditional formatting to highlight the selected cells

Can anyone tell me what the formula for 9 selections should look like?

Vic

[#2]

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

[#3]

no, this is to select only first occurance of the largest number

[#4]

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?

[#5]

I have checked the post throughoutly and I am sorry I have passed your earlier information. 

[#6]

No worries, the formulas I am now using are working fine.
Thanks for your interest
Vic