I have a large master list of baseball players and their associated stats. What I am trying to do is to create a shorter "Hot List" of only those players which meet all four of the minimums I have set for these stats.
I have attached a sample of what I'm trying to do:
- Hot List: Highlighted in YELLOW is the expected result
- Hot List: Minimum = minimum threshold for each stat (must be >= to these values)
- Master List: Complete list of players and their statistics; GREEN are >= the minimum for each stat on Hot List
The expected result is the list of players that meet ( are >=) all four of the minimum values defined on the Hot List tab.
Any ideas? Thank you for your help!
Best regards,
Eric
Bookmarks