not to use again

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Good day,
Can I enter a formula so that it would not select a number from a list if it
has already been used .
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding up total hours worked on employee schedule using various criteria 0
How to subtract a number from a Mergefield? 0
resettable, over-ridable, default cell values 0
Counting multiple memberships 1
Lookup returning wrong results 0
HELP "HOW NOT TO USE THE SAME DATA TWICE" 3
Finding location (or start cell) of highest consecutive values 3
Paste value from a formula 2

Back
Top