Getting an exact match

[Guest]

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?

 

[Tom Ogilvy]

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/[email protected]&output=gplain

http://groups-beta.google.com/group/microsoft.public.excel/browse_frm/thread/1cbf157bd1c80aa