Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting an exact match
I have a list of about 20 labor categories and hourly rates, and a total
dollar figure. I do not have the hours associated with each category. I suspect that some combination of hours and hourly rates will exactly equal the total, and that the hours will be positive integers, and most likely that all labor categories will have at least one hour. Is there macro or method that can check for a possible solution? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting an exact match
labor categories hourly rates hours
You have columns 1 and 2. Put all 1's in column 3. at the bottom say D22 put in a formula like =sumproduct(B2:B21,C2:C21) now go to Tools = Solver and set it up to solve your problem. Here are some references which explain this more fully: http://groups.google.co.uk/groups?se...&output=gplain http://groups-beta.google.com/group/...cbf157bd1c80aa -- Regards, Tom Ogilvy "Roland" wrote in message ... I have a list of about 20 labor categories and hourly rates, and a total dollar figure. I do not have the hours associated with each category. I suspect that some combination of hours and hourly rates will exactly equal the total, and that the hours will be positive integers, and most likely that all labor categories will have at least one hour. Is there macro or method that can check for a possible solution? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find an exact match and go to that match | Excel Discussion (Misc queries) | |||
Find Exact Match using INDEX, MATCH | Excel Worksheet Functions | |||
Match name not exact | Excel Worksheet Functions | |||
Getting an exact match | Excel Worksheet Functions | |||
Find a match that;s not exact | Excel Worksheet Functions |