+ Reply to Thread
Results 1 to 4 of 4

List only Items with value <> 0 in a matrix's line or column

  1. #1
    Registered User
    Join Date

    List only Items with value <> 0 in a matrix's line or column

    EDIT: Please note that I did not mention at first I posted this question on another excel forum, here's a link.


    this is my first post and as I gave a look around I could not find anything like this so please do not flame me if this is a stupid question.

    This is of course a simple example, so please do not comment on my diet

    Suppose I am currently planning my shopping on a weekly basis, and go shopping to a big convenience store weekly.
    It makes sense for me to bring my laptop with me and keep it on my shopping cart because I will be interested in the totals of each column, and I can't count .

    DIET SHEET Lattice Tomatoes Carrots Oranges Apricots Bananas Pasta Steak Fish
    Sunday 1 1 1 1
    Monday 2 1 2
    Tuesday 3 2
    Wednesday 1 1 1 1 1
    Thursday 1 2 1 2
    Friday 1 1 1 3 1
    Saturday 1 1 2 1 1
    WEEK 8 3 4 5 2 3 4 2 7

    Now suppose I am planning to move downtown, I will have to sell my car so I will do my grocery shopping daily by feet.
    My old laptop is too heavy so I want to print a sheet every day that lists only the objects that are there, without mentioning the items that are = 0; please note this is important, otherwise I will be SO utterly confused that I would soon find myself in a restaurant, or worse.

    More or less like this:


    Lattice 1
    Carrots 1
    Oranges 1
    Steak 1


    DIET SHEET Monday
    Tomatoes 2
    Bananas 1
    Fish 2

    ... and so on...
    Is there any smart and effortless way to do this, without having to copy and paste special / transpond and delete manually the empty lines? Any macros?

    Last edited by unim; 10-07-2008 at 05:38 PM. Reason: Cross posted question not mentioned

  2. #2
    Registered User
    Join Date
    Thanks, I mentioned the cross posting, sorry about that

  3. #3
    Forum Contributor mewingkitty's Avatar
    Join Date
    Fort McMurray, Alberta, Canada
    MS-Off Ver
    Excel 2003

    How's that?

    I've included my basic diet.
    If you change the names on the first page, it'll change the ones on the second page as well.

    I think that's what you were trying to do, lemme know!
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    veeeeeeery interesting!


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. comments for drop down list items?
    By zoneblitz61 in forum Excel General
    Replies: 8
    Last Post: 03-25-2020, 03:19 PM
  2. enhancing Column A through Column B
    By julia81 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-14-2008, 11:23 PM
  3. Replies: 1
    Last Post: 12-18-2007, 01:59 PM
  4. VBA: Count Items on the Same Line as Active Cell
    By BigBas in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-18-2007, 01:19 PM
  5. Going insane!
    By kik in forum Excel - New Users/Basics
    Replies: 10
    Last Post: 01-31-2007, 08:21 AM


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