Filling missing data

[york_324]

Hi all,

Can anyone advise on how to fill empty cells in Excel in Column 2, based on this example, please:

Column 1 Column 2
red
red 471
red
yellow 25
yellow
green
green
green 119
green
purple
purple
purple 4758

[daffodil11]

Column 3
=SUMIF(A:A,A1,B:B) and copy down.

Copy column 3

Paste values on 2

[york_324]

Great! That was a fast time-saving solution!
I noticed from my data that in some instances two or more of the same Column 1 values may already be addressed in Column 2. In the example, the formula applied would change the value "119" for "green" to "238". Is there a correction to the formula, please?

Column 1 Column 2
red
red 471
red
yellow 25
yellow
green
green 119
green 119
green
purple
purple
purple 4758

[daffodil11]

=lookup(2,1/(($a$1:$a$500=a1)*($b$1:$b$500<>"")),$b$1:$b$500)

[york_324]

Great! Thanks for your help!

[daffodil11]

Thanks for the feedback. Glad it all worked out.