In my worksheet I have a large area where cells are already "data validated" to only allow entries which are on a predetermined list. BUT I want to make sure the same entry cannot be entered twice in the same column. I also need to ignore some cells.
Compounding this problem is that there are 3 cells in a column, skip a cell, 3 more cells, skip a cell and 3 more.
For example:
E7 - "GF"
E8 - "PT"
E9 - "QI"
SKIP CELL E10
E11 - "KJ"
E12 - "XC"
E13 - "DH"
SKIP CELL E14
E15 - "DJ"
E16 - "BH"
E17 - "SA"
I want to make sure that the value for cell E15 is not the same as E7 (or any other cell in this column.) An optimal solution would be to eliminate the possibility of entering a duplicate value. I must do this for each column of my worksheet. My worksheet is approximately 30 columns wide. But I only want to be sure the entries are not duplicated in the columns (duplicates in the rows are acceptable and expected).
Thank you for helping. I am stumped. AS usual. . . .
Compounding this problem is that there are 3 cells in a column, skip a cell, 3 more cells, skip a cell and 3 more.
For example:
E7 - "GF"
E8 - "PT"
E9 - "QI"
SKIP CELL E10
E11 - "KJ"
E12 - "XC"
E13 - "DH"
SKIP CELL E14
E15 - "DJ"
E16 - "BH"
E17 - "SA"
I want to make sure that the value for cell E15 is not the same as E7 (or any other cell in this column.) An optimal solution would be to eliminate the possibility of entering a duplicate value. I must do this for each column of my worksheet. My worksheet is approximately 30 columns wide. But I only want to be sure the entries are not duplicated in the columns (duplicates in the rows are acceptable and expected).
Thank you for helping. I am stumped. AS usual. . . .