Drop Lowest Set of Numbers based on Averages

[jordanstuart]

I'm looking for a formula to help me determine the lowest set of data based on these characteristics. We have contests that we run that have certain base criteria. Here is what the criteria is for the 2 different states.

For Michigan you need to be 15% above the minimum and for Ohio you need to be 25% above the minimum.

[TABLE="width: 306"]
<colgroup><col><col><col span="2"></colgroup><tbody>[TR]
[TD]Month[/TD]
[TD]Minimum[/TD]
[TD]Michigan[/TD]
[TD]Ohio[/TD]
[/TR]
[TR]
[TD]Monday[/TD]
[TD="align: right"]19.33[/TD]
[TD="align: right"]22.22[/TD]
[TD="align: right"]24.16[/TD]
[/TR]
[TR]
[TD]Tuesday[/TD]
[TD="align: right"]20.87[/TD]
[TD="align: right"]24.00[/TD]
[TD="align: right"]26.08[/TD]
[/TR]
[TR]
[TD]Wednesday[/TD]
[TD="align: right"]18.44[/TD]
[TD="align: right"]21.20[/TD]
[TD="align: right"]23.05[/TD]
[/TR]
[TR]
[TD]Thursday[/TD]
[TD="align: right"]19.63[/TD]
[TD="align: right"]22.57[/TD]
[TD="align: right"]24.53[/TD]
[/TR]
</tbody>[/TABLE]

You also have to have an 88% pace to goal average for Michigan and a 90% pace to goal average for Ohio.

We drop the lowest day, but the lowest day compared to the average. We also would like for this formula to take into account pace to goal in order to have everything we need in one formula. Here is what our data looks like.

[TABLE="width: 843"]
<colgroup><col><col><col span="2"><col><col span="5"></colgroup><tbody>[TR]
[TD]Specialist[/TD]
[TD]State[/TD]
[TD]Monday[/TD]
[TD]Tuesday[/TD]
[TD]Wednesday[/TD]
[TD]Thursday[/TD]
[TD]Monday % to Goal[/TD]
[TD]Tuesday % to goal[/TD]
[TD]Wednesday % to Goal[/TD]
[TD]Thursday % to Goal[/TD]
[/TR]
[TR]
[TD]Joe[/TD]
[TD]Michigan[/TD]
[TD]20.07[/TD]
[TD]24.06[/TD]
[TD]20.33[/TD]
[TD]20.32[/TD]
[TD]92.78%[/TD]
[TD]94.33%[/TD]
[TD]99.17%[/TD]
[TD]96.53%[/TD]
[/TR]
[TR]
[TD]Brian[/TD]
[TD]Ohio[/TD]
[TD]17.73[/TD]
[TD]13.25[/TD]
[TD]17.23[/TD]
[TD]17.07[/TD]
[TD]100.00%[/TD]
[TD]100.00%[/TD]
[TD]100.00%[/TD]
[TD]99.83%[/TD]
[/TR]
</tbody>[/TABLE]


We want to make sure that this formula will flag eligible if any combination of this criteria will qualify them.