Excel Formula Help

[Netwrkengeer]

Maybe some one can help.
I need an excel formula in column "C" that will test column "B" for which cells have a correct result return (I.e. anything that doesn't return the #VALUE! comment) after that I would like the formula to copy the correct results and paste the values only to column "D" then delete the blank space.

Can someone help, I don't write excel formulas

Thanks

 

[DeLaMartre]

Good Morning Netwrkengeer,

I have a solution for you:

1) Use the formula, "=IF(ISERROR(B2),"",B2)" in column 'C'. This will return the column 'B' value unless it is an error, in which case it will return a blank cell.

2) Then copy column 'C' and "Paste Special" into 'D' clicking the box "Values" and delete the column.

Please let me know if this helps.

Surf's Up!

-Bob in California

 

[Netwrkengeer]

Yes that works,

Thank.... Is there a way do delete empty space?


Thanks

 

[DeLaMartre]

Yes. Highlight the column by clicking on the heading, and press "Delete" on your keyboard.

Is this what you mean?

-Bob in California