Hi All,

Thanks everyone for the help in advance.

I was trying to figure out a formula that will pick up a new email format when entered into excel.

Basically column D has a list of e-mail address that have traded with us. The addresses have been listed more than once for those that have traded multiple times. I copied this column into AO and removed duplicates to leave me with the number of clients we have based on their email address. I would like a formula that recognises any new email address that has traded (column D) and duplicate that email address to column AO. Is this possible?

Please see e-mail formats listed below, I'm guesisng as more than one person share an email format the formula will need "*@" somewhere.
Column D
peer@stc.com.au
peter.green@DIY.com.au
sophie@llc.com.au
andy.shaw@DIY.com.au
mike@pagin.com
sal@pagin.com