Thanks very much for responding so promptly - I think that I must be doing
something wrong as this doesn't appear to be working, or at least giving me
any answer......

Say for example this is what I have;
Column A(i.e. all the accounts my company manages)
Tesco
Sainsbury
Asda
Morrisons

And in column B (accounts my team has dealt with)
Tesco
Morrisons

I want Column C to show, or at least indicate that we should also try to see
Sainsbury and Asda

"JE McGimpsey" wrote:

Take a look at

http://cpearson.com/excel/duplicat.htm#InOneNotOther

In article ,
Bugaglugs wrote:

I've got a list of all the sales accounts that our company deals with in
column A and all the ones that have been dealt with by my team in column B -
I want to see which ones from 'A' haven't been seen by my team (i.e.
potential new opportunities).

Is there an easy way to do this?