Find first not blank, then the next?

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!!

 

VYVARN 1608 1609 1610 1611 1612 1701 1702 1703 1704 1705 1706 1707 1708 1709
030130303302   1251                        
030986338001                         6172  
0310.6043                   615        
0310.9054           332   333            
0310.9092   299   179                    
0315901854           369                
0318776     26                      
0318778     32                      
0319778     490                      
032555302376                 1686          
0325562601   1845         1443   1598          
0330328         2015                  
0330334                     2769      
0344863     1014                      
03509355               664            
03509638     390                      
03509899         695                  
035DS 351 320-011     695     484                
035HL 351 029-061B           1190                
035HL 351 029-101B           461                

By: Jeppe Nygaard

Leave a Reply

Your email address will not be published. Required fields are marked *