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
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