Select your data rangedataadvancedunique
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Nancem" wrote in message
...
I've got 2 worksheet with about 25 pieces of data. I need to be able to
identify when one of the pieces of data are not the same in each
worksheet. I
created concatonates in the first column of each (columns in each
associated
with account #, billing # and name). That's my join info. I want to be
able
to id those where the phone # on each are not the same. Would I do a
vlookup?
How do I do that in home and student 2007. Formula please