In column B (B2:B21) I want users to enter only WHOLE numbers between 1 & 20 (no specific order). Once the user has entered all 20 numbers I have recorded a macro to Sort my table by column B, ascending.
Using Data Validation I can restrict the user to entering only a whole number between 1 & 20 but can I also use data validation to stop any 'duplicate' entries. i.e. I only want the user to be able to enter each number once.
Can this be done using Data Validation?
Using Data Validation I can restrict the user to entering only a whole number between 1 & 20 but can I also use data validation to stop any 'duplicate' entries. i.e. I only want the user to be able to enter each number once.
Can this be done using Data Validation?