How do I Countif A1=B1 or A1=C1 or B1=C1 any help would be appreciated, thank you
M Mitymack May 14, 2006 #1 How do I Countif A1=B1 or A1=C1 or B1=C1 any help would be appreciated, thank you
M Max May 14, 2006 #2 Mitymack said: How do I Countif A1=B1 or A1=C1 or B1=C1 any help would be appreciated, thank you Click to expand... 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
Mitymack said: How do I Countif A1=B1 or A1=C1 or B1=C1 any help would be appreciated, thank you Click to expand... 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
