Need to return a value from a column when two values from are equal

The only situation that I'm aware of where Excel will display beyond the boundaries of a cell is:

a) cell contains text string and b) the cell(s) to the right are completely empty.

If you really don't want to expand the column, you're going to have to put the formula in B inside the =TEXT() function to convert the number to text and you are going to have to clear (completely) column C. If the formula in column C is important, then you'll have to decide if you want to expand column B, or if you can move the formula in C to D.

Thanks Mr. Shorty but is there a way to do this using VBA in the background so the cells would be blank and would allow the value to extend past the cell boundary if the statement is true?

I'm sure there is. It's not the kind of programming I do, so I'm not real good at it. something like

Please Login or Register  to view this content.

where condition is a boolean that decides when you need this action, and i,j are index numbers to indicate which cell needs to be cleared. I'm assuming that you will have already wrapped the function inside the TEXT() function so it will spill out into the adjacent cell once it is cleared. If you want, you can put this inside of a change or calculate event procedure if you want the code to run automatically with the appropriate event. You may also need an Elseif to restore the formula in the cleared cell when you need that formula

Please Login or Register  to view this content.

where formulastring is a string variable/constant that stores the necessary formula

one data enter in a column then same data enter in same column and indimate already enter in excel macro. how to do vba code?

Bump.

Still tying to figure out how to do this with ranges as opposed to each individual cell.

Please Login or Register  to view this content.