Forum Discussion
Complicated lookup involving multiple Max values and secondary conditions - WORLD CUP EDITION
I'm building a spreadsheet to track and bracket the World Cup. Anyone familiar with the rules knows that there are multiple logical criteria for determining who progresses. Reference this screengrab:...
This sounds like it can be done. It's a task that could get convoluted very quickly though. It would help to see all the checks listed beyond column C then a formula could be drawn up. MODE might be useful to determine if there are duplicate max entries. If MODE produces an error, the max is unique, etc.