ExcelBanter - not to use again

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - not to use again (https://www.excelbanter.com/excel-worksheet-functions/147779-not-use-again.html)

ekkeindoha

not to use again

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

Toppers

not to use again

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 .

All times are GMT +1. The time now is 08:35 AM.