Hi,

Does anyone know of a formula that will fill in the missing values of one row with the row(s) beneath it, if the rows beneath it contain values and if they meet a certain criteria (and then paste this formula down an entire column)?

Below is an example of the before and after scenarios which should make my question easier to understand.

Attachment 201334

If anyone can help it will be greatly appreciated.

Thank you