Take a look at this:
http://www.jlathamsite.com/uploads/for_mdma.xls
No code in it, all done with formulas. I've included a sheet with my
attempted explanation of how I arrived at the result, plus an added sheet
where the formulas are put to work so you can see it all in action.
I hope this comes close to what you want, and if not, well, then I'll just
have to work a little harder won't I?
"mdma" wrote:
in the constants :
areas will be upto 5 different areas
as for the results, there will be 5 types of results, each then with
the expected and min / max levels
The number of actual result lines (ie ref) could be anything between
100 and 1000.
--
mdma
------------------------------------------------------------------------
mdma's Profile: http://www.excelforum.com/member.php...o&userid=24284
View this thread: http://www.excelforum.com/showthread...hreadid=553169