Hi,

Am Mon, 26 Sep 2016 10:10:52 -0700 (PDT) schrieb Miss:

I am writing to request macro (VBA function), which allows to me to see different data value (from column K and L from duplicate rows of data.

For example ? please input sheet from the attachment.

Process ? the macro, should look through lines of data which have duplicate name values (from column A), identify which rows from column K and L are different from the duplicate values. The macro should highlight the difference in yellow, as final output.

Expected output ? please see output sheet from the attachment.

have a look:
https://onedrive.live.com/redir?resi...=folder%2cxlsm
for "sample file"
There is a formula solution. The helper column can be hidden.


Regards
Claus B.
--
Windows10
Office 2016