Hi everyone, I need some help in a small piece of VBA that finds the average of days for each month. Column 1 has the months and column 2 had the number of days. Sample of date as well as desired output below. Any help would be greatly appreciated.
Nick
Nick
Month | Days | Month | Avg | ||
September | 4 | September | 5.5 | ||
September | 4 | October | 5.88 | ||
September | 4 | November | 7.44 | ||
October | 4 | ||||
November | 4 | ||||
November | 4 | ||||
September | 4 | ||||
September | 6 | ||||
November | 8 | ||||
October | 8 | ||||
October | 8 | ||||
November | 7 | ||||
September | 8 | ||||
November | 8 | ||||
November | 8 | ||||
November | 12 | ||||
October | 8 | ||||
October | 8 | ||||
September | 8 | ||||
September | 6 | ||||
November | 8 | ||||
October | 8 | ||||
October | 3 | ||||
October | 3 | ||||
October | 3 | ||||
November | 8 |