Try this:
1)Select A1:A10 (with A1 as the active cell)
2)Data>Validation
Allow: Custom
Formula: =COUNTIF(A$1:A1,A1)=1
Then, with A15:A20 (A15 active)
Data>Validation
Allow: Custom
Formula: =COUNTIF(A$15:A20,A15)=1
Those will allow any entry in the lists, but no duplicates.
Does that help?
--
Regards,
Ron
Bookmarks