RobRooster
New Member
- Joined
- Feb 14, 2021
- Messages
- 3
- Office Version
- 2019
- Platform
- Windows
Hello everyone,
I need help in figuring out how to write a formula that finds 1 cell that meets two max criteria. I have tried several formulas such as VLOOKUP, MAXIFS, and INDEX(MATCH). For my example I want a formula that chooses the option that has the highest effective % but also the highest times chosen. In this case it would be Option EE that has been chosen 4 times with a effectivity of 100%. Using the formula I have on the right side it gives me Option C which is the first option it encounters with 100%, although it is really not the most effective. I also need to find the Least effective which would be Option Z, but I figure that would be changing from MAX to MIN.
Any help will be greatly appreciated!!
Example Below:
I need help in figuring out how to write a formula that finds 1 cell that meets two max criteria. I have tried several formulas such as VLOOKUP, MAXIFS, and INDEX(MATCH). For my example I want a formula that chooses the option that has the highest effective % but also the highest times chosen. In this case it would be Option EE that has been chosen 4 times with a effectivity of 100%. Using the formula I have on the right side it gives me Option C which is the first option it encounters with 100%, although it is really not the most effective. I also need to find the Least effective which would be Option Z, but I figure that would be changing from MAX to MIN.
Any help will be greatly appreciated!!
Example Below: