If this issue has been solved elsewhere, please direct me to it and accept my apology - haven't been able to find it myself.
Problem:
Building a tournament scheme.
Need to check value in pairs to rank players proberly.
E.g.:
If A1 or A2 contains "W.O." check next pair (four pairs in total).
If next pair (e.g. A7 and A8) doesn't contain "W.O." (but names) check value in B7 and B8.
If B7 > B8 -> output A7
Hope this makes sense...?
I have tried IF(OR(...)) but I get stuck (my brain can't figure it out..)