My fault :-(

I'm working in a danish version of excel.

Substitute semicolon with comma in the formulas.

Regards,
Per

"Wanna Learn" skrev i meddelelsen
...
Thanks I tried both formulas (sorry)
it tells me that formula contains an error thanks

"Per Jessen" wrote:

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