You are reading a single comment by @Chalfie and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
@Chalfie
So you have a standard starting price for each product (jan?)
say that's in cell a1
then feb - aug in b1 - whatever1
so
b1-$a$1 will give you the monthly difference
(b1-$a$1)/$a$1 will give you percentage difference
you can use this page (if you want) to get moving averages
https://www.ablebits.com/office-addins-blog/2015/09/25/moving-average-excel/