+ 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
    10-07-2008
    Location
    Milano
    Posts
    3

    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.

    http://www.mrexcel.com/forum/showthread.php?t=345819

    Hi,
    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:

    DIET SHEET

    Sunday
    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?

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

  2. #2
    Registered User
    Join Date
    10-07-2008
    Location
    Milano
    Posts
    3
    Thanks, I mentioned the cross posting, sorry about that

  3. #3
    Forum Contributor mewingkitty's Avatar
    Join Date
    09-29-2008
    Location
    Fort McMurray, Alberta, Canada
    MS-Off Ver
    Excel 2003
    Posts
    949

    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
    10-07-2008
    Location
    Milano
    Posts
    3
    veeeeeeery interesting!

    Thanks

+ 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

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