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...
I have checked the post throughoutly and I am sorry I have passed your earlier information.
No worries, the formulas I am now using are working fine.
Thanks for your interest
Vic
Thanks for your interest
Vic