0

I have downloaded sales data from webstore and the rows are itemised, but they only provide the date in one cell for the order.

I am trying to work out how I can auto fill the blank cells with the missing dates automatically?

I will then have the same data on another sheet so it would need to carry over for when the dates are filtered.

enter image description here

Improve this question
3
  • What should the values be? We can't invent the missing dates.
    – TZubiri
    Commented May 14, 2019 at 18:43
  • @Tomas I take it that the omissions are just repetitions of the above values like you would find in a pivot table.
    – Wolfgang Jacques
    Commented May 14, 2019 at 19:28
  • Yes exactly they are to be repeated. Each row used represents a sold product item within the customer order but it only shows the date once. The issue I have is that order sizes (number of items) varies, so rather than define a specific cell, I need to try some thing like if the cell below is empty, enter the value from the above cell. Sorry i am still a novice so my explanations might not be the best.
    – ShadowFingers
    Commented May 15, 2019 at 19:08

1 Answer 1

Reset to default
0

You can use something like =IF(A4="";B3;A4) to take the above date if the left cell is empty. You will possibly have to use an auxiliary column for that.

Screenshot

Improve this answer
1
  • Thanks Wolfgang. I will give this a try. Thank you so much, I really appreciate you taking the time to help.
    – ShadowFingers
    Commented May 15, 2019 at 19:11

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .