Nov 23 2018 08:51 PM
=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
Dec 04 2018 11:48 PM
Dec 05 2018 04:27 AM
no, this is to select only first occurance of the largest number
Dec 05 2018 04:32 AM
Dec 05 2018 05:12 AM
I have checked the post throughoutly and I am sorry I have passed your earlier information.
Dec 05 2018 07:19 AM