Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba custom function sum highest consecutive numbers in range excel
I am trying to write a custom function HICON which takes 2 arguments :the
range to be used and the number of consecutive cells to be used . The idea is that if for example the range was A1:A100 and the number was 5 the formula would evaluate the sum of A1:A5 then A2:A6 and so on until it got to A94:A100 then it would use whichever of these sums gave the highest total as the result of the function. Can anyone suggest the VBA code to use in EXCEL 2003 for this function please. Email for replies is Thank you |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Highest total of any three consecutive numbers in a range. | Excel Worksheet Functions | |||
how do i highlight the ten highest numbers in a range? | Excel Discussion (Misc queries) | |||
Highest 3 in 10 Consecutive Numbers | Excel Worksheet Functions | |||
Highest 5 numbers in a range turn red | Excel Discussion (Misc queries) | |||
How do I add only the highest three numbers in a range of data? | Excel Worksheet Functions |