Contest Results based on 4 Criteria

Morning,

I'm having an issue formulating results based on a different criteria. I've attached an example, and below is what I'm looking to accomplish.

1. First Qualifier is 100% Performance to Plan (Col C.)
2. If they are >=100% Performance to Plan (Col C.) then look at YOY Growth (%) (Col. D), this is the 1st Place Winner.
3. If they are >=100% Performance to Plan (Col. C.), and they are not the 1st Place Winner in Col. D, then 2nd Place Winner (No repeat winner, if 1st place is same as a previous qualifier, than the 2nd place person wins that Column.
4. If they are >=100% Performance to Plan (Col C.), and are not repeat winners in Col. D or Col. E, then the leader of Column F will be 3rd Place.

Thanks,

rO