Deleteing


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?action=getinfo&userid=28639
View this thread: http://www.excelforum.com/showthread.php?threadid=488070

.

Relevant Pages

  • Re: Find and Replace against set of rules in 2nd table/worksheet
    ... find and replace cells in a certain column? ... mkwan23's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30210 ... Prev by Date: ...
    (microsoft.public.excel)
  • Adding Time (hours and minutes)
    ... I did try to format the cells as Time. ... bengaluru's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24188 ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • help needed with "if" statement
    ... (In other words, I'd like the function to know to add cells a2, a3 and ... Gina ... gina_b's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29996 ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Protecting specific cells from recalculation.
    ... in other cells to assign those numbers, but the drop down list removes ... re-calc while leaving the rest of the sheet under automatic re-calc? ...
    (microsoft.public.excel)
  • Ignoring #DIV/0!
    ... tillyosu's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=25114 ... Prev by Date: ...
    (microsoft.public.excel.misc)
Loading