Is someone able to help me with a formula for excel that would allow excel to identify if data has been input twice. For example if I lifted information from one document to put into an excel document and it is mixed alpha and numerical (awdhq58749648), what formula can I use in excel to identify if the same (awdhq58749648) has been input into the worksheet somewhere else.

Cheers Reddawn :confused2: