Ok, I want help with a formula.

Here is what I want to acheive:

B....................................C
......................................1234
......................................1541
Number already in use......1234

So, if there are any duplicate entries within the whole of column C, I want the cell adjacent to it within the B column to read "Number already in use.

Thanks

Craig