How Do I Compare one cell to an Entire Column

  • Thread starter Thread starter ExcelAlex
  • Start date Start date
E

ExcelAlex

Thank you.

That worked great. Now, to make matters worse: I need to compare data
in A1 and B1 to any data in Columns C & D but keeping in mind the 2
data are paired:

Thus-
IF
(Cell in Column 1 and Cell in Column 2) = (Any Cell in Column 3 and
Adjacent Cell in Column 4)
THEN
Column 3 = "TRUE"

I Tried this but it didn't work:
=IF((COUNTIF(C:D,A1:B1)>0),TRUE,FALSE)


Please advise!
Alex
 

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.

Ask a Question

Similar Threads

Excel Comparing two columns 1
Comparing pairs of cells in four columns 7
VBA Excel partial cell compare to another cell 0
Excel How to find the most common pairs and triplets numbers? 5
comparing 2
Compare 2 uneven colums 2
comparing two columns 2
How do I compare the data in Cell A1 with the data in Cell A2 3

Back
Top