with refer to this link:
http://support.microsoft.com/default...b;en-us;213185
you can use this formula =COUNTIF(A:A,A1)=1
for data validation to prevent duplicate entry. This is very simple and
easy to understand.
with refer to this link:
http://support.microsoft.com/default...b;en-us;213185
you can use this formula =COUNTIF(A:A,A1)=1
for data validation to prevent duplicate entry. This is very simple and
easy to understand.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks