Does this help?
a) Use Conditional Formatting for non matching sets
b) Use Sumproduct(...) for duplicate rows in a Set*
If a duplicate row is deleted, the Conditional Formatting must updated
(Copy, EditPaste SpecialPaste: Formats)
Ola Sandström
Note:
Example zip-file:
http://www.excelforum.com/attachment...tid=3583&stc=1
* =COUNTIF(...,...)1 array entered (Ctrl+Shift+Enter) can also be used
+-------------------------------------------------------------------+
|Filename: Book5.zip |
|Download:
http://www.excelforum.com/attachment.php?postid=3583 |
+-------------------------------------------------------------------+
--
olasa
------------------------------------------------------------------------
olasa's Profile:
http://www.excelforum.com/member.php...o&userid=17760
View this thread:
http://www.excelforum.com/showthread...hreadid=385770