not to use again

E

ekkeindoha

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

Toppers

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
 
Top