Check for doubled-up figures

J

Jonibenj

How can I run a check on a column of figures to make sure that I haven'
doubled-up any of them? In other words, each number is only allowed t
be entered once, so if any of them appear more than once, I want to b
notified at the bottom.

Jonatha
 
J

Juan Pablo González

Put this formula next to the numbers

=COUNTIF(A:A, A2)=1

assuming your data is in column A, and starts in A2.

It will return TRUE for each unique number, or FALSE for each item that is
repeated.
 
J

Jim May

Use conditional formatting;
Click on Column Header A,
Format, Conditional Formatting,
Select "FormulaIs" and enter:
=COUNTIF($A:$A,A1)>1
Select Shade Yellow, say
OK out...
HTH
 
J

Jonibenj

Thanks Jim, that's even better than Juan's tip as it doesn't take an
extra column.

Jonathan
 
Top