Hi all, (system= windows 7 excel 2013)
I’m trying to make a formula that will show me the trend in selling prices.
My system shows me everytime a new price have been made, but if a new price have not been made is just show nothing.
but to show the development using a graph, i need the value to continue and only change if there is a new price, and the continue with the price
Below is a ex:
The columns are month and year and the rows are produkt lines. in the first line all the month/year should be 1251. And in the 5 row is should start being 299 then change to 179 for the next columns.
I have tried to use this formular INDEX = (Q3: AD3; MATCH (FALSE; ISBLANK (Q3: AD3), 0)) as a array formular, and it short of works, but not completely
all help is much appreciated!!
|035DS 351 320-011||695||484|
|035HL 351 029-061B||1190|
|035HL 351 029-101B||461|
By: Jeppe Nygaard