Column comparison

[avinkris]

How do I compare two columns A,B and extract the unique values from B to another column C.

[Tony Valko]

Show us some sample data along with the result you expect.

[avinkris]

I want to compare these two columns and paste the values that are unique to B in C

Please Login or Register  to view this content.

[Tony Valko]

Show us what results you expect.

[avinkris]

the result must be like in column ( I have updated the table above)

[Paul Cherian]

do you want to get the unique values in Column A and B to column C ? So your result should be Column C right?

[Paul Cherian]

http://www.extendoffice.com/document...o-columns.html

Hope it Helps!

[Paul Cherian]

Try this one too..

http://www.get-digital-help.com/2009...array-formula/

[sktneer]

Try this Array formula which requires confirmation with Ctrl+shift+Enter instead of just Enter.

in C2

Please Login or Register  to view this content.

and copy down.

[Tony Valko]

Ok, looks like you want items from column B that are not in column A.

Data Range

	A	B	C
1	List1	List2	In B but not in A
2	0000000481te1a6	0000000481te1a6	0000001001rj535
3	0000000481te1a6	0000000481te1a6	0000001002nz922
4	0000000483te123	0000000483te123	0000001003edb83
5	0000000483te123	0000000483te123
6	0000000485te0ac	0000000485te0ac
7	0000000485te0ac	0000000485te0ac
8	0000000486tec6c	0000000486tec6c
9	0000000486tec6c	0000000486tec6c
10	0000001001cb724	0000001001cb724
11	0000001001edb06	0000001001edb06
12	0000001001nz5e2	0000001001rj535
13	0000001001nz5e2	0000001002nz922
14	0000001002ed7c6	0000001003edb83

Enter this array formula** in C2:

=IFERROR(INDEX(B:B,SMALL(IF(ISNA(MATCH(B$2:B$14,A$2:A$14,0)),ROW(B$2:B$14)),ROWS(C$2:C2))),"")

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

Copy down until you get blanks.