Data validation to prevent duplicate entry.
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. |
All times are GMT +1. The time now is 10:03 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com