Posted to microsoft.public.excel.misc
|
|
Compare lists and highlight matches
Take a look he
http://www.cpearson.com/excel/duplic...tractingCommon
"srain001" wrote:
Hi,
I have two lists that I'm trying to compare to see if there are any
similarities. The lists are quite extensive. Is there a formula out there
which can match the entries AND highlight them?
any help would be appreciated.
thanx
S.
|