Recent DiscussionsMost RecentNewest TopicsMost LikesSolutionsTagged:TagRe: Data Validation on column with concatenated cells Steverm25 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.