Hi,
There are a live set of orders and helis for each plant every release day of the week. Some plant's days are not changed very often (and are therefore sometimes not on the 'log' for months) but will always have a defined number of orders and helis.
For each week in the year (weeknum) I need to capture the live number of orders and helis for each release day
Some plants and days are exported more than others. In the example data, for instance, the latest sunday release day at plan DN53 would have been on 05/06/20 but all other days have been exported more recently.
The week 43 live tab would therefore show all DN53 Mon-Sat from 20/10/2020 and sun orders and helis from 05/06/2020.
The formula must return (in the live tab) the latest orders and helis for each release day of each plant. This will be captured weekly (for each financial weel)- 'live' tab will show a record of orders and helis for every release day and plant for each week (weeknum) of the year.
Example data:
In 'log' tab, shows raw data of exported orders and helis for each plant and each release day
'Live Tab'- where the formula must return number of helis and orders (every week end a new weeknumber will be entered with corresponding list of plants and release days, we must therefore be able to copy the formula down for each new week)
Hope this makes sense
Thanks
Bookmarks