ExcelBanter - Number is not entered twice in a column or row

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

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

- - Number is not entered twice in a column or row (https://www.excelbanter.com/excel-discussion-misc-queries/149724-number-not-entered-twice-column-row.html)

Boris the Spider

Number is not entered twice in a column or row

Hi

Does anybody out there know if there's a way I can stop someone entering a
value in a row/column that is a duplicate of another value already there?

Thanks

Toppers

Number is not entered twice in a column or row

Try Data=Validation

Allow: Custom

Formula is: =COUNTIF(A:A,A1)=1

HTH

"Boris the Spider" wrote:

Hi

Does anybody out there know if there's a way I can stop someone entering a
value in a row/column that is a duplicate of another value already there?

Thanks

All times are GMT +1. The time now is 04:58 AM.