Hi!

To get rid of the duplication (at least to make it invisible) perhaps
conditional formatting.

"If C2=C1 then make C2's text colour same as its background". Copy
Down.

Alf


---
Message posted from http://www.ExcelForum.com/