Thanks so much for your response. When using an array formula do I need to
remove the surrounding open and close braces before entering into the cell?
Otherwise, only the formula appears in the cell.

However, if I delete the braces I get an error message with the formula with
a request to "accept the change". When I accept the change the results pasted
are #REF!. Can you tell me what's going on here?

Regards,
Greg

"pgeraf" wrote:


Hi Greg,
I think what you are looking for is an Array formula. Try this:

Put this formula in Sheet2!A2 and press Ctrl+Shift+Enter to convert it
to an array formula. Then copy it all the way down to reproduce the
number of cells where the e-mail addresses are included in Sheet1 (the
e-mail addresses should start at cell A2 in Sheet1). Hopefully, if it
woks as it did with me, it will eliminate all duplicates. This formula
will work with anything you list in Sheet1.

{=IF(SUM((Sheet1!A2=Sheet2!$A$1:A1)*1)=0;Sheet1!A2 ,"")}

Enjoy!


--
pgeraf
------------------------------------------------------------------------
pgeraf's Profile: http://www.excelforum.com/member.php...o&userid=10067
View this thread: http://www.excelforum.com/showthread...hreadid=522459