Change the validation type to custom and use
=AND(ISNUMBER(MATCH(Me, CrewName, 0)), COUNTIF(D1:D10, Me) + COUNTIF(J1:J10, Me) = 1)
... Where Me is the address of the active cell when you enter the formula.
Change the validation type to custom and use
=AND(ISNUMBER(MATCH(Me, CrewName, 0)), COUNTIF(D1:D10, Me) + COUNTIF(J1:J10, Me) = 1)
... Where Me is the address of the active cell when you enter the formula.
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks