Fill a column with the same formula as previous cell no blank

Hi

I have a table with two columns; first dates and second codes and blank cells.
Each code represents a formula. I want to fill with values the second column, applying a different formula to each cell with each code and to all the blank cells below.

Basically the idea is to fill a range of empty cells automatically with a formula.

I give a simple example in the attached file.

Thanks

Did you mean to attach a file? If so, it didn't quite make it.

MFT,

I'm not sure I understand. Your "expected results" already contain formulas that seem to deliver the expected results. What do you want to achieve?

can you try explaining again

MFT,

I think you should engage helper columns like you did in the attached sample. Otherwise, if you try to apply the formulas to column B directly, you'll end up with circular references.

Typically, in a well designed spreadsheet, you'll either have data entry cells or cells with formulas. Creating a column where the cell contents is either a value or a formula will always pose difficulties.

I'm still not sure about your requirements, because your column B shows text in some cells, but the required results have formulas in the same row.

Assuming that you want to show the text values in column B, you can create helper columns to calculate your values and then show a summary column that draws its values from the helper columns. Then hide the helper columns to create the illusion of only two columns.

Hide all the shaded columns in the attached spreadsheet to end up with just two columns, delivering ( I believe) the result you are after.

If that does not do it for you, I'm afraid you'll need to do some more explaining.

Do you want the result in column B? You have the text value in column B, and that text value determines the formula to be used for the calculation, so you cannot have the formula in column B as well as the text values.

The requirements are still not completely defined, I think.

Is this the same question, for which you got an answer for here?

http://www.excelforum.com/excel-gene...ank-cells.html

if so, please do not create duplicate questions... it wastes people's time as they don't know another thread is being worked on by someone else, and that you already received a satisfactory result.

And you should close a thread if you didn't get a satisfactory answer...