If you're going to use a macro for adding the duplicates to the cell comments, you may as well forego the formula entirely and use the macro to handle all the processing, perhaps tied to a selection_change event intersecting the data range, so the data are kept current.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]