Hi all

How do i delete all the cells in a column in which a formula did not
work, leaving the cells where the formula did work?

Example
#DIV/0!
#VALUE!
193%
49%
#VALUE!
44%
-11%
-23%
#VALUE!
#VALUE!

Without going through them individually

as there is a lot and i dont want to do that....

thanks
Andrew


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