ExcelBanter - how do not allow a number to be repeated on the same column?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how do not allow a number to be repeated on the same column? (https://www.excelbanter.com/excel-discussion-misc-queries/126720-how-do-not-allow-number-repeated-same-column.html)

christine Helou

how do not allow a number to be repeated on the same column?

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

Teethless mama

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

All times are GMT +1. The time now is 06:22 AM.