Re: $$Excel-Macros$$ Computer moving average hrs of play per day

2011-10-01 Thread Ken
I solved it with a combination of VLookup to get the date that is X days (X is the number of days of play that I want to average) prior to the current date (VLookup by default picks the value in the data that is less than the specific number/date if no match is found, if I did not play on a specif

Re: $$Excel-Macros$$ Computer moving average hrs of play per day

2011-09-29 Thread dguillett1
Send your file with a complete explanation and before/after examples to dguille...@gmail.com -Original Message- From: Ken Sent: Wednesday, September 28, 2011 1:03 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Computer moving average hrs of play per day I have a spreadsheet