List Formula

[mkd]

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

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

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

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

without spaces...
Which formula can I use?

Thanks.

 

[Don Guillett]

I have a problem with excel.

For example, I have a generic list like this:



3,40

2,05

#N/A

#N/A

#N/A

-1,5

#N/A

2,30



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

following form



3,40

2,05

-1,5

2,30



without spaces...

Which formula can I use?



Thanks.

use data>autofilter>filter for it