For B2:B....,D2:d..., and E2:E..., apply custom data validation with the formula
=COUNTIF($F:$F,$F2)=1
For B2:B....,D2:d..., and E2:E..., apply custom data validation with the formula
=COUNTIF($F:$F,$F2)=1
Bernie Deitrick
Excel MVP 2000-2010
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks