Nov 27 2022 12:49 PM
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:
For cells D2 through D8, I want to get the "winner" of that group of 4. This is a complicated prospect. If the max value is unique, it's the max value. However, if there are more than one of the max value (in this case, "4"), then I need the formula to reference C2 through C8 only for those duplicate max values (in this case, C2 and C8) and for whichever of those numbers is largest, return the original max value from column D. In the case that those two numbers also match, I need to reference a third column the same way (find the max of two adjacent values).
Does this make sense?
Nov 28 2022 05:51 AM
Nov 28 2022 01:11 PM - edited Nov 28 2022 01:12 PM
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.