Need help comparing columns!

[gcarabajal]

Hi all, I was wondering if it's possible to do as follows:

Given a text list (placed on column A) and another one (placed on column B), being the second an extract of the first one. Can I obtain (on column C) the text fields present on column A but not on column B?? Thank everyone in advance, doing this manually is killing me

 

[VoG]

Try in C1 copied down

=IF(ISNA(MATCH(A1,B:B,0)),A1,"")

 

[TiaXL]

I think you mean =IF(A1=B1,A1,"")

<TABLE style="WIDTH: 48pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=64 x:str><COLGROUP><COL style="WIDTH: 48pt" width=64><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 48pt; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height=17 width=64 x:str=""></TD></TR></TBODY></TABLE>

<TABLE style="WIDTH: 48pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=64 x:str><COLGROUP><COL style="WIDTH: 48pt" width=64><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 48pt; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height=17 width=64 x:str=""></TD></TR></TBODY></TABLE>

 

[gcarabajal]

Thanks for your quick reply!

@VoG: It didn't work :/, it says that is an error on the formula.-

@TiaXL: Let's see if I can make myself clearer. This is for knowing which tapes I have outside a tape library.

In column A, I have all the tapes. In column B I have the tapes inside the library. In Column C I want the tapes that are outside the library.

Tape names are as follows: NNXXXXL3

I hope I made myself clearer on what I'm looking for. Once again, thanks for your help.-

 

[justme1122]

You can try a countif:

=COUNTIF(B:B,A1)

Copy and paste this down colum C and you get a 0 for those that arnt in B:B and a count for those that are.

You could also put it into an if

=if(COUNTIF(B:B,A1)=0,"then this","otherwise this")

 

[VoG]

No error here

Excel Workbook
	A	B	C
1	a	b	a
2	b	c
3	c	f
4	d		d
5	e		e
6	f
Sheet5

 

[gcarabajal]

It finally worked!

=IF(ISNA(MATCH(A2;B:B;0));A2;"")

@VoG: I had to trade the commas by semicolons and that made the trick. Thank you very much VoG and all of you guys that reply this .-