Forum Discussion
Data Validation on column with concatenated cells
Thanks Hans. I appreciate that is where the problem is. Columns A, B + C individually don't need to (and can't be) unique. It is only the combined information that make up a drawing number (e.g. G(0-)01) that has to be unique (i.e. I can't have to drawing number the same).
as a set of examples:
G(0-)01 -ok
G(0-)02 - ok
G(2-)01 - ok
A(0-)01 - ok
But a further copy of the same data (e.g. another G(0-)01 , not ok)
It looks like VBA may have to be the way to go, but disabling undo would be unacceptable). Otherwise, might just have to live with being careful and checking manually for duplicates.
Thanks Hans. I appreciate that is where the problem is. Columns A, B + C individually don't need to (and can't be) unique. It is only the combined information that make up a drawing number (e.g. G(0-)01) that has to be unique (i.e. I can't have to drawing number the same).
as a set of examples:
G(0-)01 -ok
G(0-)02 - ok
G(2-)01 - ok
A(0-)01 - ok
But a further copy of the same data (e.g. another G(0-)01 , not ok)
It looks like VBA may have to be the way to go, but disabling undo would be unacceptable). Otherwise, might just have to live with being careful and checking manually for duplicates.
Creating the data validation rule on column C based on column AW as described in my previous reply will help - I assume that you will mostly enter a value there after entering a value in columns A and B.