I have Data for each week starting from Jan to Dec 2019,i want to Pic dynamically the current week data among 53 weeks .
Based on the entries in the excel source file ,every week output will get changes.Here i do not have any date field in my source file
Please find the attached source and output screen shot..
Solved! Go to Solution.
@joshi does act_1, act_2.....so on, does these are week numbers?
If yes, does that mean at end of the year it will be act_53/52 depends on the year, correct?
and you want to pick the value from most recent week data is available in the sheet, correct?