+ Reply to Thread
Results 1 to 3 of 3

Filter list based on criteria from other cells

  1. #1
    Registered User
    Join Date
    01-08-2013
    Location
    Santa Cruz, CA
    MS-Off Ver
    Excel 2010
    Posts
    2

    Filter list based on criteria from other cells

    Hi,
    I'm trying to set up a sheet for the office that will give us a quick print out of inventory.
    I have a csv I can export which I would like to draw from using some array formulas in order to create a list of all items with a positive quantity. My first column is the list of items, second is the corresponding quantities. I've been online for about 3 hours now trying to put a solution together, but I feel like I've gotten nowhere.
    I need my resulting list to be all the items with a non-zero quantity and the quantity number along side it.

    I have my simple attempt which leaves blank spaces on zero values:
    Please Login or Register  to view this content.
    And my over-complicated attempt (which I barely understand) that duplicates entries where the previous list left them blank:
    Please Login or Register  to view this content.
    I appreciate your input in advance.
    Last edited by aviemet; 01-08-2013 at 10:15 PM.

  2. #2
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: Filter list based on criteria from other cells

    Does the first formula actually work? or does it miss something?
    If it works, and all you want is to get rid of the blanks, Use the the filter to remove them...select range, filter, uncheck (blanks)

    Hope this helps
    A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
    -Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
    -To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
    If you received helpful response, please remember to hit the * of that post

  3. #3
    Registered User
    Join Date
    01-08-2013
    Location
    Santa Cruz, CA
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Filter list based on criteria from other cells

    I did figure this one out.

    Please Login or Register  to view this content.
    This does the job, gives me only greater than 0, nonempty inventory items.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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