Hi all,
I am trying to create a file which reads 3 different types of data from 3 worksheets and plots it against the week selected in master sheet.
Example file attached. I know this requires index and match formulas but I am unable to finish it.
It also requires a 4 wk and 12wk average calculations and I tried using the offset/average formula but it didnt work.
Help please!
What would be expected result??Originally Posted by dksodhi
For actual you can try
E5Formula:
Please Login or Register to view this content.
Drag down
Unmerge the C Column
Last edited by shukla.ankur281190; 05-16-2017 at 04:01 AM. Reason: Missing info
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Could you input expected results for "A", esp for 4 , 12 weeks avg
Quang PT
You will need to unmerge cells in D, put product in each of the 3 cells, if you want to drag down the formula.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks