Match problem

[dickpierce]

Please help with the following. Below is the desired result.
Column C is what I'm trying to get as a result.
a b c
Abreu Aaron Abreu
Adair Adcock Adair
Adams Agee Adams
Agee Alfonso
Alfonso Allen
Alicea Allison Alicea



Thanks in advance.

 

[Todd Bardoni]

See my formula in the post above.

 

[Todd Bardoni]

=IF(COUNTIF(B:B,A2)>0,"",A2)

Does this work?

 

[dickpierce]

Holy Crap Bardoni! Your formula worked!!!!

I'll name my first born after you.

I was trying Match and VLookup, and some formulas I even tried to invent.

Thank you so much for your patience.

 

[Aladin Akyurek]

Holy Crap Bardoni! Your formula worked!!!!

I'll name my first born after you.

I was trying Match and VLookup, and some formulas I even tried to invent.

Thank you so much for your patience.

Seems you almost exhausted Todd...

Lookup formulas would work too. For example...

=IF(ISNUMBER(MATCH(A2,B:B,0)),"",A2)

would be faster than COUNTIF.

 

[dickpierce]

Aha! I knew it! Thanks for this formula also. But I don't dare use it. Bardoni might just have me killed.

 

[Todd Bardoni]

My frustration was well worth coming to a solution for you.

And actually, you don't need to say greater than 0:-

=IF(COUNTIF(B:B,A2),"",A2)

will suffice.

And of course if speed is an issue, Aladin's formula is what you need.