Filling in empty cells in columns

K

koba

Dear All

I have a problem could somebody please help?

I have 3 columns of data A,B,C. A nd B are full but not all the cells
in C are filled out. How do I make the cells in C that are empty equal
the value in B without having to do it manually and still keeping the
existing values in C?

Please help

Much Appreciated

Andrew

PS Thank you to whoever helped me last time I didn’t get a chance to
say that.
 
B

bpeltzer

Select your entire data set and turn on autofilters: Data > Filter >
Autofilter. Use the drop-down in column C to select blanks. In the first
row remaining visible, enter the formula to copy the value from column B (ex:
if it's row 39, then in C39 you'd enter =B39). Autofill the formula down
through all the visible rows.
 
Top