Prevent Duplication

[Agility]

How do I create a formula that would show me if a number is used more than once in a column? I am not trying to create unique numbers I want any duplication of numbers to stand out.

 

[VBA Geek]

How do I create a formula that would show me if a number is used more than once in a column? I am not trying to create unique numbers I want any duplication of numbers to stand out.

Use conditional Format to make duplicates stand out:

https://support.office.com/en-us/ar...in-excel-34402f91-c7e7-4060-944c-65d913033d18

 

[philwojo]

you could try something like this:

=COUNTIF(H1:H14,H1)

that will look for what ever the value is in H1 in the range of H1:h14 and tell you how many time it occurs. If that count is greater than 1 you then would know there is a duplicate.

Is that what you are looking for?

You would update the H1 and H1:H14 references to fit your needs and range.

 

[Agility]

Thank you ......