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?