Good morning,
i have a manager who wants to average a set of cells.
he there are indefinate number of cells in a row and he wants to average
only the current entry plus only the last three consecitive entries.
example:
if a1,b1,c1,d1,f1 all have entries he wants the average based on the info in
b1,c1,d1,f1.
when e1 has data entered he wants the average to be based on c1,d1,f1,e1.
there are 20+ rows that need to have this function.
can someone help, this is beyond my capabilities.
thanks
doug