Without actually seeing the data, it's hard to think of a ready built-in function that will do it. I expect Solver would tackle this problem pretty easily once you get the spreadsheet set up.