Results 1 to 1 of 1

Thread: Need some small Excell help

  1. May 4th, 2002, 10:58 AM #1
    T-Tank
    T-Tank is offline

    Thread Starter
    New Member
    Join Date
    May 2002
    Posts
    1

    Lightbulb Need some small Excell help

    Hi all,
    I hope someone can help me with my problem

    First, look at the attached image
    It's a small automation-program I'm working on.
    After each Product number, theirs the amount of that product that a person has bought.

    I want to create a new sheet where I can see all the orders personID 25 has made,
    it should only have two columns,
    The first one that shows all the prodnr's that personID 25 has ordered and the second one shows the amount of that prodnr(how many times it was purchased by this person), prodnr's with a zero should be ignored.

    I was trying to do this with some matrix-formulas but I just can't get it to work, maybe somebody here can help me...
    thx
    Attached Images Attached Images  
    Last edited by T-Tank; May 4th, 2002 at 12:33 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width