If function clarification

[Guest]

I have a column in which some of the cells have input values, and some don't.

I need to have someway of having excel do the following:

If F1 has a value, do nothing
If F1 is blank, insert the value in cell E1.

However, AI am not sure how to do this without "typing" over the values
currently in column F

Any assistance would be great.

 

[Peo Sjoblom]

It's better that you continue in the original thread you started


in E1 put

=IF(F1="",F1,"")

 

[Guest]

Thanks - however, column E has values in all cells and I need to maintain
them. My goal is to simply copy the value in E1 iinto F1 if there is not
value in F1.

Thanks

 

[Peo Sjoblom]

Then it is not possible unless you use event macros

http://www.cpearson.com/excel/events.htm

 

[Arvi Laanemets]

Hi

It's possible stepwise.

Into some free column enter formulas like
=IF(F1="",F1,E1)
Copy the range with formulas, and Paste Special as values into column F (you
overwrite your old data)
Delete formulas you entered before.


Arvi Laanemets

 

[BobT]

Or use another column
=if(F1="",E1,F1)
then copy the column and paste values in column F