Results 1 to 8 of 8

Thread: how to dynamically change the quantity?

  1. #1
    Seeker test4me's Avatar
    Join Date
    Nov 2019
    Posts
    5
    Articles
    0
    Excel Version
    2016

    how to dynamically change the quantity?



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello!
    There are products that are identical by name and same by price but the products codes are different.
    When seller sells products writes only the name of the product, the quantity and its price, because of the goods are different by code
    and same in price it is impossible to determine which product is sold.
    I determine the product code by date, price and name, but I canít take the quantity into account dynamically.
    Can you help me with advice how to dynamically change the quantity of a sold product?

    Thank You

  2. #2
    Acolyte caabyyc's Avatar
    Join Date
    Dec 2014
    Location
    Burnaby/Calgary
    Posts
    29
    Articles
    0
    Excel Version
    2016
    1 sample Excel Spreadsheet with dummy data source and desired output is better than tons of words.

  3. #3
    Seeker test4me's Avatar
    Join Date
    Nov 2019
    Posts
    5
    Articles
    0
    Excel Version
    2016
    example of dummy data
    Attached Files Attached Files

  4. #4
    Seeker test4me's Avatar
    Join Date
    Nov 2019
    Posts
    5
    Articles
    0
    Excel Version
    2016
    any idea guys how can I do this?

  5. #5
    Administrator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,680
    Articles
    0
    Excel Version
    2010 on Xubuntu
    We don't expect you to bump threads more than once in 24 hours. Please remember that those who help here do so voluntarily and of their own goodwill. They live in many different time zones and many will be out at work right now if they are not asleep on the other side of the globe. This is not a paid 'service': members will help when they are ready and able to do so, and not 'on demand'. Please do not try to put pressure of time on anyone here: if you get the help you need today, that's fine, but you really should not count on it. Thanks for your understanding and patience.
    Thank you Ken for this secure forum.

  6. #6
    Seeker test4me's Avatar
    Join Date
    Nov 2019
    Posts
    5
    Articles
    0
    Excel Version
    2016
    Good day Pecoflyer! in fact, I don’t hope for an fast help and why do you think that I put pressure on anyone? any help would be useful to me who could advise to solve my problem.
    Last edited by test4me; 2019-11-02 at 10:54 AM.

  7. #7
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,284
    Articles
    0
    Excel Version
    Office 365 Subscription
    You showed impatience by bumping the thread after only four hours (post #4) - you should not bump your threads unless 24 hours have passed.

    Your sample data is not clear - you need to explicitly show (manually mocked up) the results that you want.
    Ali
    Enthusiastic self-taught user of MS Excel!

  8. #8
    Seeker test4me's Avatar
    Join Date
    Nov 2019
    Posts
    5
    Articles
    0
    Excel Version
    2016
    AliGW! thanks for the explanation I will try to simulate what I want to get from this

Posting Permissions

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