Modify a column of data with a logic argument, copy paste down etc..

Hi,

There is an example attached, please look.....0

Ref in column A with duplicates, Number in column B unique for each ref, there cannot be any line that has the same number for both.

Further along there is a value but it is currently filled in only once for each ref where it is filled in at all, and will be against the one with the lowest number in column B.

All I want to do is make a formula to copy and paste down the list next to it to fill in the same value for the rest of a given ref if there is already a value against it. I have done this already in my example where there are only 2 of a given ref and it works fine for that. Unfortunately there are a few that occur more than twice and I am struggling to work out how to do this.

Imagine the real list is huge and the idea is to copy and paste the formula all the way to the bottom and then copy and paste the values over the top of the original column to amend and fill in the missing values.

The list can be sorted so that each ref is in order by number, lowest to highest, the value in the value column will always be against the lowest number for each ref.

Many thanks for any help.

Hi there,

Thanks for trying to help me, this is not quite what I mean, there are also refs that are unique with no value against them, those should remain as they are, even if 0, like in my example. The only ones I am missing are the ones near the bottom where there is more than one duplicate of the same ref.

Yep works perfectly, many thanks for your help