I have three columns and want an average price for the week when the week changes.
this is going to update daily so a VBA programme would be best but i will accept anything!!!
Price Week Ave. Price
1.50 18
2.50 18 x(for week 18)
2 19
3.00 19
4.50 19
1.75 19 x(for week 19)
Cheers
this is going to update daily so a VBA programme would be best but i will accept anything!!!
Price Week Ave. Price
1.50 18
2.50 18 x(for week 18)
2 19
3.00 19
4.50 19
1.75 19 x(for week 19)
Cheers