Comparing to see no matchs

[SALO]

I have one column of stock symbols in column (A) In column (B) I have another list of stock symbols. In column (C) (or cell??) I would like to make a formula that looks in column (A) and Column (B) and tells me just the symbols that dont match. Is there a way to do this? Anyhelp would be appreciated.

SALO

 

[davesweep]

Hi,

In cell C1

=IF(ISNUMBER(MATCH(B1,A:A,0)),"",B1)

and copy down


Dave

 

[carddard]

Or you could do it in VBA:

Sub match()
lastrow = Range("A65536").End(xlUp).Row
For i = 2 To lastrow
    
    If Cells(i, 1) <> Cells(i, 2) Then
    Cells(i, 3) = "Do Not Match"
    End If
    
Next
End Sub

 

[Peter_SSs]

I have one column of stock symbols in column (A) In column (B) I have another list of stock symbols. In column (C) (or cell??) I would like to make a formula that looks in column (A) and Column (B) and tells me just the symbols that dont match. Is there a way to do this? Anyhelp would be appreciated.

SALO

SALO

Can you clarify a couple of things...

1. Do the symbols need to match side-by-side (like Code 1 below) or just anywhere in the columns (like Code 2 below)

2. Are the lists in each column the same length?

3. If my sample data is feasible, what results would you expect from it?

4. If my sample data is not feasible, can you explain why, or provide some small samples and expected results yourself?

Excel Workbook
	A	B
1	List 1	List 2
2	Code 1	Code 1
3	Code 2	Code 6
4	Code 3	Code 3
5	Code 4	Code 4
6	Code 5	Code 2
Matching

 

[SALO]

quote=Peter_SSs;1661297]SALO

Can you clarify a couple of things...

1. Do the symbols need to match side-by-side (like Code 1 below) or just anywhere in the columns (like Code 2 below)
Anywhere

2. Are the lists in each column the same length?
No

3. If my sample data is feasible, what results would you expect from it?
Basically have to columns of symbols, Just want to non matching symbols as I mention in my thread. I know could just put them in one coluns then sort them alphabetically and then I would visually see repeat symbol side by side. Just thought there was a formula or better stratygie for this. 4. If my sample data is not feasible, can you explain why, or provide some small samples and expected results yourself? Explained above but I will try the idea of the other threads and let you all know if it works. Thanks for the help

Matching

 

[Peter_SSs]

Would Conditional Formatting like this be any use?

1. Select A2:B7
2. Format|Conditional Formatting...|Condition 1|Formula is: =COUNTIF($A$2:$B$7,A2)=1|Format...|Patterns|choose colour|OK|OK

Adjust the selected range and the range in the formula to match your data.

Excel Workbook
	A	B
1	List 1	List 2
2	Code 1	Code 1
3	Code 2	Code 6
4	Code 3	Code 3
5	Code 4	Code 4
6	Code 5	Code 2
7		Code 7
8
Matching

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2	1. / Formula is =COUNTIF($A$2:$B$7,A2)=1	Abc