Assume source data within A1:C10
Put in D1: = --OR(A1=B1,A1=C1,B1=C1)
Copy down to D10
Col D will return either a zero if FALSE, or a 1 if TRUE
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
