View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ROland ROland is offline
external usenet poster
 
Posts: 72
Default 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?