| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
need to make a macro to sum the highest 3 values from 10 coluns
I need to make a macro thta select the 3 highest values from 10 coluns and
then sum up these values... |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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... |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Top 3 highest values | Excel Discussion (Misc queries) | |||
| How do I get Excel to make highest #, 1 color, & lowest # another? | New Users to Excel | |||
| Construct Coluns via VBA | Excel Programming | |||
| 3 highest values | New Users to Excel | |||
| Macro closes all coluns and not just the programmed ones, why? | Excel Programming | |||
Linear Mode
