List Formula

M

mkd

I have a problem with excel.
For example, I have a generic list like this:

3,40
2,05
#N/D
#N/D
#N/D
-1,5
#N/D
2,30

I would like (NOT VBA!) that excel give me a list without #N/D, in the
following form

3,40
2,05
-1,5
2,30

without spaces...
Which formula can I use?

Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top