Thread: how do not allow a number to be repeated on the same column?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default how do not allow a number to be repeated on the same column?
Select your data range then go to:

Data Validation Settings Allow: select Custom Formula:
=COUNTIF($A$1:A1,A1)=1

"christine Helou" wrote:

I want to not allow the entry of a number more tan once on the same colunm
Reply With QuoteReply With Quote