How to limit dropdown list values to only be selected once per sheet
I am trying to figure out if it is possible to create a dropdown list and then enforce that each of the potential values could only be selected once per sheet.
I have a sheet with two columns. Project Name and Project Priority.
Project Priority is a dropdown list with preset values.
If I select the Project Priority as "2" for line one I do not want to be able to have any other lines chosen as "2" for that column.
Is this usage where each of the potential values in the dropdown list is unique and can only be selected once possible with the system?
Is this a feature request perhaps?
Help Article Resources
Check out the Formula Handbook template!