List Formula

Discussion in 'Microsoft Excel Discussion' started by mkd, Jul 31, 2012.

  1. mkd

    mkd Guest

    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.
     
    mkd, Jul 31, 2012
    #1
    1. Advertisements

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.

Share This Page