You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more
I have what I think is a relatively simple problem, but my brain appears to be on strike. Basically I want to track sales of our product in one of our customers stores. The idea is that I can cut down on merchandising costs by flagging sales decreases over a rolling 4 week period. If a stores sales decrease for 4 weeks in a row I need it to show so that I can arrange a visit.
I’m missing something simple here aren’t I?
All help appreciated 😕
You probably want to look at conditional formatting of some form to highlight the cells that have shown a negative of a certain value or percentage over the proceeding ones and then some sort of IF formula to show that if it is negative over a number of the cells it highlights it a different colour.
Was going to suggest conditional formatting too. Maybe with formula including equation last week minus one or something.
use OFFSET to return moving ranges, gives you a rolling X month average
OFFSET variables start with a an "Origin", then steps left/right and up/down, followed by the width and depth of the array you want to return. Good for moving around time series data.
Thanks guys. I’ll have a play around tomorrow