Forum Discussion
Solved
Data Validation on column with concatenated cells
I am trying to use data validation on a column which has a concatenated formula combining 3 cells from other columns to ensure that the combined data is unique (i.e. columns A,B + C can have many dup...
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.
I know this is an old thread but I have same issue with a drawing register. I have used the conditional formating to alert for any duplicates.