Results 1 to 43 of 43

Dynamic formula, (copy from dynamic formula and ignore 0)

Threaded View

  1. #1
    Registered User
    Join Date
    05-25-2013
    Location
    denmark
    MS-Off Ver
    Excel 2010
    Posts
    52

    Dynamic formula, (copy from dynamic formula and ignore 0)

    1. i have an dynamic list that grows.

    2. im trying to make a formular that will follow the growth of the first list, the funktion of this formula is to copy the first list but ignore zeros/empty cells


    List 1:

    Somthing 1: Somthing 2
    Jan: 2
    feb: 4
    april: 0
    Dec: 3
    Mar: 1

    What i want my formula to do:

    Somthing 1: Somthing 2
    Jan: 2
    feb: 4
    Dec: 3
    Mar: 1
    Last edited by Kartoffelmos; 10-21-2014 at 04:08 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. dynamic range formula to ignore #DIV/0 error
    By jmfrancis21 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-04-2013, 03:18 PM
  2. Replies: 0
    Last Post: 02-28-2006, 09:10 PM
  3. Replies: 0
    Last Post: 02-28-2006, 09:10 PM
  4. Replies: 0
    Last Post: 02-28-2006, 09:10 PM
  5. Dynamic Range with unused formula messing up x axis on dynamic graph
    By cabybake@yahoo.com in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-02-2006, 04:10 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1