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

Try this:
Select the range you want to test
EditGo to
Click the [Special Cells..] button
Select:
Formulas
Uncheck everything except Errors
Click [OK]

If that selects the right cells....
Press the [Delete] key...Done

Does that help?

***********
Regards,
Ron


"koba" wrote:


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

Brilliant

thanks worked a treat


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