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.


--
koba
------------------------------------------------------------------------
koba's Profile: http://www.excelforum.com/member.php...o&userid=28639
View this thread: http://www.excelforum.com/showthread...hreadid=483280

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.

"koba" wrote:


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 didnt get a chance to
say that.


--
koba
------------------------------------------------------------------------
koba's Profile: http://www.excelforum.com/member.php...o&userid=28639
View this thread: http://www.excelforum.com/showthread...hreadid=483280

Thanks heaps worked a treat!!!

Andrew


--
koba
------------------------------------------------------------------------
koba's Profile: http://www.excelforum.com/member.php...o&userid=28639
View this thread: http://www.excelforum.com/showthread...hreadid=483280