Cell pair comparison

Discuss the spreadsheet application
Post Reply
Munding
Posts: 43
Joined: Wed Feb 18, 2015 7:57 pm

Cell pair comparison

Post by Munding »

Hi all,

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..) :knock:
OpenOffice 4.1.2 on Windows 10
FJCC
Moderator
Posts: 9653
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Cell pair comparison

Post by FJCC »

Please upload a small spreadsheet with examples of data. The data can just be invented to illustrate the problem.
To upload a file, click Post Reply and look for the Attachments tab just below the box where you write a response.
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Post Reply