Replicating the next cell above that contains data

Capture1.JPG so it is the price column

Hi and welcome to the forum

Pictures are of little value. Honestly, no one wants to re-type your data to try and solve your issue. Additionally, we would only be guessing at how your data was structured, ie. formulas, formatting, etc. Additionally, due to how some browsers behave, many of our members cannot see uploaded pictures/images. Please do not take this route.

Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.

Include in the attachment any code you're currently using (whether it works or not) and an "After" of what you wish the output to be.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

Hi, sorry I am new to this, where is the option to add a workbook? The column titled 'Price/t' contains the different prices paid for each contract. The cell at the bottom (highlighted red with exclamation mark) needs to replicate the next cell above that contains data >0, regardless of the other prices.

but I'll try, maybe this one will help:

=INDEX($B$2:$B$10,MATCH(99^9,$B$2:$B$10))
see att.

I was just in the middle of uploading it, but that was the answer I needed thanks! That's working just the way I need it to. Thanks again, sorry I'm new to this!

You mean thanks for instruction How to upload workbook or Solution?

Anyway thanks for the feedback and mark thread solved