Hi

With your Agent numbers in column B, paste this formula in C1 and copy it
down as desired:

=COUNTIF($B$1:$B$500;B1)

Or selet B1:B500 goto Format Conditional formatting Condition1:
Formula is In the empty field enter:
=countif($B$1:$B$500;B1)1

Format as desired OK OK

Hopes this helps

---
Per

"Wanna Learn" skrev i meddelelsen
...
Hello I have a spreadsheet with agent numbers-over 400) each number
should be unique. I cannot use random because I do not want to change the
numbers of the existing agent number. Is there a formula that would tell
me
if a number already exist in the column - Numbers must be random thanks