What is wrong with the answers given in your previous posting?
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Geo" <[email protected]> wrote in message
news:[email protected]...
> I have 20 numbers in a row (G34:Z34) I would like to average the last 5
> entries. So if I have 10 entries (G34:P34),I would only like to average
> (L34:P34) Which is the last 5 entered and continue on averaging the last
5
> all the way to (Z34).
> --
> Geo
Bookmarks