need to make a macro to sum the highest 3 values from 10 colun
Actually, you can enter it normally - it doesn't need to be entered as an
array formula.
--
Regards,
Tom Ogilvy
"Duke Carey" wrote:
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...
|