Hi, I'm trying to set up excel data validation from table column, and want it to be dynamic so that if the rows increase the validation applies. I named the range, then set the data validation to =countif(namerange,c2)<=1. I see the validation in every cell, but it allows me to enter a duplicate. what am I doing wrong?
Solved by V. J. in 18 mins