do not repeat numbers in a column

  • Thread starter Thread starter Wanna Learn
  • Start date Start date
W

Wanna Learn

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
 
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
 
Thanks I tried both formulas (sorry)
it tells me that formula contains an error thanks
 
My fault :-(

I'm working in a danish version of excel.

Substitute semicolon with comma in the formulas.

Regards,
Per
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top