Example Data

29-Jan-09 05:30 1.0000 35.344 -34.344
30-Jun-08 08:00 356.0000 29.710 326.290
02-Dec-02 09:50 120.0000 21.236 98.764
28-Nov-02 09:20 280.0000 17.800 262.200
21-Nov-02 17:26 Pt Created 20.579 #VALUE!
#N/A #VALUE! #N/A No Good Data
#N/A #VALUE! #N/A No Good Data
#N/A #VALUE! #N/A No Good Data

I need the speadsheet to ignore the cells with none numeric entries as the
cells are used in calculations for an SPC chart. columns B C and D extract
data from an external database (PI). I think I may need some sort of macro
to do this?

Help!


"Gord Dibben" wrote:

Fix the bad cells is the best solution.

Why are they bad?

Can you trap for the errors and return "" instead of errors?

Posr a few examples of bad cells.


Gord Dibben MS Excel MVP

On Thu, 26 Feb 2009 02:12:06 -0800, nicmoo
wrote:

How do I get excel to skip over bad cells (containing none numeric errors)
and procede with auto calculation?