Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Checking a column of values against another one
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Checking a column of values against another one
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 -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "BRob" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Checking values in 2 columns | Excel Worksheet Functions | |||
Checking for exsitence of values in a different worksheet | Excel Discussion (Misc queries) | |||
Checking for Multiple Values | Excel Discussion (Misc queries) | |||
Checking on two values | Excel Discussion (Misc queries) | |||
Checking ALL values in a range | Excel Discussion (Misc queries) |