Data Sort

  • Thread starter Thread starter Ryan F
  • Start date Start date
R

Ryan F

I have two columns of data that runs into the thousands.

e.g.
Column A Column B
AU/TCACNEILQ01 AU/TCABRAXASN01
AU/TCACOAA01 AU/TCACAIDAUN01
AU/TCACRICKTV04 AU/TCACCGAMN01
AU/TCACRICKTV04 AU/TCACCOAUSN01
AU/TCACRICKTV05 AU/TCACECOMPN01
AU/TCACRICKTV05 AU/TCACERCOMN01
AU/TCACTIVEIN01 AU/TCACERCOMN02
AU/TCADELSA02 AU/TCACHGLOBN01
AU/TCADIDN01 AU/TCACIERN01
AU/TCADMAN01 AU/TCACOAA01

What is the fomular, or how do I match data in column A
to Column B to find out all the data that doesn't have a
match, and produce an output column?

Regards
Ryan
 
Back
Top