I have a situation where I have various "projects" with varying numbers of team members assigned to each. Each of those members may be assigned software "options", but cannot share options, nor can they be assigned more than one.
I need to be able to find and highlight any pair of duplicate values in my columns, but only if they both belong to the same "project" in another column.
Conditional Formatting rows is easy, as they only need to have more than one duplicate value.
Using =COUNTIF($D31:$G31,"<>")>1
Columns get tricky because I expect duplicate values in the whole column, just can't occur in the same group of rows, (Identified by project # in another column.)
Bookmarks