View Single Post
 
Old 02-22-2022, 07:51 AM
IamThatGuy IamThatGuy is offline Mac OS X Office 2021
Novice
 
Join Date: Feb 2022
Posts: 14
IamThatGuy is on a distinguished road
Exclamation multiple validation on a column to avoid duplicate entries

In the attached, tab 'Working'...

is there a way to:
  • Add validation so duplicate entries are not allowed. Would normally use Data validation for this but this is already being used
  • Restrict users from typing into column A. i.e. be forced to use the Drop down only

Thank you in advance
Attached Files
File Type: xlsx IDExample.xlsx (14.4 KB, 10 views)
Reply With Quote