Using data validation, with list in D1:D10 and data entry in column E:

In column E set DV to:

Custom

Formula: =COUNTIF(D1:D10,E1)=1

HTH

"ekkeindoha" wrote:

Good day,
Can I enter a formula so that it would not select a number from a list if it
has already been used .