not allowing duplicates if 2 criteria are met
Hi, I am trying to find a way to limit entries based on 2 criteria. For
instance, if column A, row 13 is Smith and row 14 is red, it won't allow
column A row 16, Smith and row 17 red, but it would allow Smith, Blue.
Basically, I want to fill 2 cells with info and not have both cells repeated
somewhere else in that row. The 2 rows will always be in numerical order by
the way. Is this possible?
|