+ Reply to Thread
Results 1 to 2 of 2

Auto-selecting of cells to match a specific value

  1. #1
    Registered User
    Join Date
    Hong Kong
    MS-Off Ver
    Excel 2003

    Auto-selecting of cells to match a specific value

    Dear all

    Recently I was given a specific value (e.g. $14,340.32) and was asked to find the combination(s) for that value on a long inventory list, a list containing 1,000+ items with different names and prices. What I do now is to sort the prices and manually try to match the prices by myself and I find it's extremely ineffective and inefficient (in short, stupid).

    So I would like to ask if there is any function/skill/add-in that can help me to perform the above task?

    Thank you for your time to this matter, much appreciated your help.

    Best Regards,

  2. #2
    Forum Expert Palmetto's Avatar
    Join Date
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010

    Re: Auto-selecting of cells to match a specific value

    Excel has a built-in feature called Solver that you may find helpful in this task.

    Take look here for a Solver Tutorial

    Here is a recent post in which Solver was used and a sample workbook is available:
    Find the best combination of scenarios
    Last edited by Palmetto; 09-08-2009 at 03:57 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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