Find cumulative averages

Hello all,
In excel i have a list of dates and names in cols a and c,related data in cols v,w,x,y is it possible to find a running average for this data and place the results as follows
Average col v in col aq
Average col w in col ar
Average col x in col as
Average col y in col at
Some names have no data available,see attached worksheet.The lists are very long so a macro would be the ideal solution.Many thanks for any help given.

Hi Bigband,


Unable to understand the data fully.
How you are arriving at 39.00 in cell AQ2?

Thanks.


Regards,
DILIPandey

<click on below 'star' if this helps>