I have a 2 part problem that I am having issues with... mainly part 2. I have gotten the first part to work by itself.
1) I have a column which contains part numbers (###-#####-###). I am using data validation to make sure that there can be no duplicate part numbers entered in the column.
Here is the custom formula that I am using:
=COUNTIF($A:$A,A2)=1
2) I also want to force the values of the cells in the part number column into a custom format (###-#####-###). Any value that does not use the proper amount of numbers would prompt a message to the user. This one I am not completely sure how to accomplish.
Thanks in advance for your help!