in column C, put in a formula like

In C1 put in
=if(Countif($B:$B,A1)=0,"Unique to A","")

In D1 put in
=if(countif($A:$A,B1)=0,"Unique to B","")

Select C1:D1 and drag fill down

--
Regards,
Tom Ogilvy


"Jim Gregg" wrote in message
oups.com...
Hello,

I am wondering if someone could offer some assistance. I have 2 columns
in a worksheet. The two columns are lists of server names. I would like
to compare the list in column A and Column B and either output or
highlight unique values. I basically need to figure out what column A
is missing from column B and vice versa. I appreciate any help anyone
can offer. Thank you.

Jim Gregg