Checking a column of values against another one

B

BRob

In column A I have about 110 integers in the range 100 to 20,000 (eg 141,
162, 352, etc.)

In column B I have about 600 integers covering the same range.

What I want to do, for every entry column B, is to put an entry in column C
to say whether the value is in column A

eg

A B C

1 7 Y
7 1 Y
9 22 Y
22 4 N

Can SKS help

Tx

Rob
 
A

Andy Pope

Hi,

In C use this formula

=IF(COUNTIF($A$1:$A$4,B1)>0,"Y","N")

Adjust $A$1:$A$4 to require data range and then copy the formula down

Cheers
Andy
 

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

Creating a dynamic chart range where the range to be graphed depends on the contents of a cell 0
Checking values in 2 columns 4
Creating a Simple Bar Chart - 2 Areas for help please 4
Help with column accumulation needed 2
Comparing two columns and returning value from another column 1
charting multiple identical x values overlapping 0
I need Time Range to return Value 4
Permutations andText to column problem 6

Top