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.
Similar Threads
  1. Terra S.

    Need Help Nesting a Formula inside MAX formula

    Terra S., Oct 20, 2003, in forum: Microsoft Excel Discussion
    Replies:
    8
    Views:
    438
    Fábio Coatis
    Oct 21, 2003
  2. Dmitriy Kopnichev

    How to place a cell formula after the formula result in the cell?

    Dmitriy Kopnichev, Nov 27, 2003, in forum: Microsoft Excel Discussion
    Replies:
    10
    Views:
    455
    Ron Rosenfeld
    Nov 28, 2003
  3. Dom Boyce

    insert formula using VB - displays formula as string, not result

    Dom Boyce, Feb 27, 2004, in forum: Microsoft Excel Discussion
    Replies:
    1
    Views:
    394
    Niek Otten
    Feb 27, 2004
  4. Bill

    count results of formula, not text in formula

    Bill, May 5, 2004, in forum: Microsoft Excel Discussion
    Replies:
    4
    Views:
    1,054
    Dave Peterson
    May 8, 2004
  5. urmaniac13

    formula forming Q for Formula One :-D

    urmaniac13, Jun 8, 2004, in forum: Microsoft Excel Discussion
    Replies:
    3
    Views:
    179
    Papparotti
    Jun 8, 2004
Loading...

Share This Page