need to make a macro to sum the highest 3 values from 10 coluns
You can use an array formula to do it, without resorting to a macro:
=SUM(LARGE(A1:J1000,{1,2,3}))
enter it by pressing Shift-Ctrl-Enter
"Antonio" wrote:
I need to make a macro thta select the 3 highest values from 10 coluns and
then sum up these values...
|