Hello,

Could someone help me with this.

I need to fill colum C based on the date of collum B and E.
It has to take the date (B) from the first apple in this case 1-1-2017 and then look at collum E Which date it will first encounter when it's going down.
And then the Vedor behind that date (F) has to be filled in collum C. As example I allready have filled the first 2 rows.

Image

Excel dates.PNG

If you have any question I would be happy to answer them,

Bob