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

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

thank you so much. that has worked a treat.

i made the formula "real life" into a hidden sheet, and now the user
just has to post the data into the initial sheet and it will then
update a summary sheet accordingly.

again, thanks alot :)


--
mdma
------------------------------------------------------------------------
mdma's Profile: http://www.excelforum.com/member.php...o&userid=24284
View this thread: http://www.excelforum.com/showthread...hreadid=553169