Hi Did you get the answer for this if no
you can write to me on my email address
which is

Thank you
Gregory

"Monk" wrote:

Hi..,
I have a lengthy list of cells with numbers within them (say A1:A500) and
wish to have a formula which would instantly detect if any of the cells
contains the same number (duplicate). Ideally the formula would return a
€˜Duplicate Number message within a specified cell (say C1) and if possible
highlighting both of the duplicated cells in a different colour.

Thanks in advance,
Monk