two columns of numbers, need to sort/filter to find one number th.
 

I get a list, hundreds of account numbers....A week later a get a second
list, the same list as before except one of two accounts are missing...
Need to sort or filter out the accounts that are NOT in the second list but
were in the first, basically the accounts that are NOT on both lists....

Thanks.

Hi
see:
http://www.cpearson.com/excel/duplic...#InOneNotOther

--
Regards
Frank Kabel
Frankfurt, Germany

"Larry in Seattle" <Larry in schrieb
im Newsbeitrag
...
I get a list, hundreds of account numbers....A week later a get a
second
list, the same list as before except one of two accounts are
missing...
Need to sort or filter out the accounts that are NOT in the second
list but
were in the first, basically the accounts that are NOT on both
lists....

Thanks.