Using Excel To Identify Entries That Add To A Specific Value.mp4




About this tutorial:

Video duration: 5:5
Have you ever encountered a large number of transactions and needed to find which of those transactions added to a specific amount? If so, then you’ve likely engaged in a tiresome and time-consuming manual trial-and-error process and may not have been able to find the right solution. Fortunately, as demonstrated in this tip, using Excel’s Solver tool to find the right answer makes short work of this task.

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

12 thoughts on “Using Excel To Identify Entries That Add To A Specific Value.mp4

    Will

    (June 12, 2018 - 4:32 am)

    I'm getting an error… "Run-time error '53' File not found: Solver32.dII"

    varner313

    (June 12, 2018 - 4:32 am)

    "Objective Cell contents must be a formula" is the message I keep receiving. I'm unable to get my answer, please advise and thanks

    Russell Fennell

    (June 12, 2018 - 4:32 am)

    does this just return the first combo it finds? What if there are multiple

    Jet Yeo

    (June 12, 2018 - 4:32 am)

    thanks… and if I would like to limit the selection to only 4 data from the list by having the total value of X, how could i do it?

    Andrew Taylor

    (June 12, 2018 - 4:32 am)

    It wont let me run the solver since my objective cell needs a formula…

    ahmed darwish

    (June 12, 2018 - 4:32 am)

    Hi.. If you are interested in an alternate method to achieve the same results without the 200 entries limit. Please do let me know.. My method has no limitations.

    ahmed darwish

    (June 12, 2018 - 4:32 am)

    Hi.. If you are interested in an alternate method to achieve the same results without the 200 entries limit. Please do let me know.. My method has no limitations.

    Cyndi Schreier

    (June 12, 2018 - 4:32 am)

    It fails, even though I'm repeating everything exactly and I know it should have a match

    Catpol catpol123

    (June 12, 2018 - 4:32 am)

    Just use SumMatch add-in to get a list of solutions!

    John Jones

    (June 12, 2018 - 4:32 am)

    how are you getting the sum of column C?  i get a "#value!" error since they are formulas in the cells and not values.  i am using =sum(C2-C200).

    Kamil Wantuch

    (June 12, 2018 - 4:32 am)

    Hey there, thanks for the tutorial. Do you know if there is any way to make excel show different solutions? Or show all possible solutions?

    Jill Martin

    (June 12, 2018 - 4:32 am)

    Very useful info

Leave a Reply

Your email address will not be published. Required fields are marked *