View Single Post
  #2   Report Post  
Juan Pablo González
 
Posts: n/a
Default

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.

--
Regards,

Juan Pablo González
Excel MVP

"Jonibenj" wrote in
message ...

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

Jonathan


--
Jonibenj
------------------------------------------------------------------------
Jonibenj's Profile:
http://www.excelforum.com/member.php...o&userid=17048
View this thread: http://www.excelforum.com/showthread...hreadid=469063