Posted by Dave Benham on June 09, 2001 8:22 AM
I have a question regarding Excel that I've been trying to come up with an answer to - and failing.
I have a spreadsheet of information that is sorted alphabetically, and by date. The last column provides a list of data that I wish to know the average of.
I am aware that this can be done in Excel, but this is thrown out of synch when new data is added to the top of a previous listing.
My spreadsheet has 1300 entries at present, with approximately 25 new entries being made each day.
For instance, I want to average cells p7 - p18 - which is easily accomplished, but then a new alphabetical entry to be included in the average goes in at p6 and it all has to be redone. Is there a way to do this?