comparing two columns to see which rows are NOT matched

marching rows

[manny33]

i am a newbie here and i have data from two sources relating to sales by store...i have the imported data in two columns A and B ....if there are THE SAME STORES and DIFFERENT STORES in the columns...and both are sorted numberically..but there are hundreds of stores...how can i detect those stores listed in column A that are NOT in column B, and vice versa .. thank you in advance...manny

[SuzyUK]

Hi manny welcome to WW

when you say imported, what have you imported your data into? s/sheet, database

and also when you say sorted numerically, does each store have a unique ID, no matter which column it's in?