Prevent matching entries on same row from appearing in the Data Validation dynamic range.

[Nitefox]

I have the dynamic named range 'UnitList' set for a drop down list data validation for both columns H and J (from rows 6 on). However H and J should never have matching entries. Is it possible to edit the Data Validation source formula to remove the entry from the dynamic range that matches the H or J column on the same row to prevent them from ever matching? Or is there another way of achieving the same thing?

[JBeaucaire]

It's a bit of a "hack", since this doesn't really stop them from duplicating entries, but it makes it look like they haven't.

I would suggest Conditional Formatting in column J that turns the font invisible of the value selected is already selected in H of that row.

Or, you could leave it visible and have both cells turn bright red to basically scream "error".

[Nitefox]

My thinking was that when they selected an entry in H, that entry is no longer an option in the J drop down list (and visa versa) making it not possible for the user to select a duplicate entry. Is that not possible?

[kvsrinivasamurthy]

Pl see attached file.

[Nitefox]

Thank you. However its only on the same row that they cannot match, not the entire column.

[kvsrinivasamurthy]

Pl see attached file.

[Nitefox]

Thank you.