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.

3

1 Answer

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.

1

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy