Hi Guys,
Hoping someone can help.
I am trying to automate a spreadsheet....
I want a column to spit out data after matching a specific date and also automatically calculate the average for last 4 weeks on the same day!
for eg: If today is 23rd Jun - I want the column to pick this value and also the value a week before which would be 16th Jun. And then do the average of the last 4 weeks!
I tried vlookup and match but cant seem to figure it out.
Attached example...can someone help please.
Is it possible to have the dates in the real date format? something like dd-mmm-yy?
it will be difficult if not possible otherwise
Please make the Post as solved, when you get your answer & Click * if you like my suggestion
The numbers in your example don't seem the match the data in your columns to the left.
6/23 x=20, 6/16 x=20.. etc
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
Thank you for looking into it.
@Akki: Updated file attached with date format
@daffofil: made a last minute change to dates and didnt update the actuals..updated now
Maybe with an pivot table.
See the attached file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Others may have a better and short formula
test-Answer.xlsx
Thanks Akki. Works like a charm! Superstar!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks