ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   filter or validate to avoid repeated data (https://www.excelbanter.com/excel-worksheet-functions/156369-filter-validate-avoid-repeated-data.html)

Fabricio Recalde

filter or validate to avoid repeated data
 
If you are entering data such as serial numbers and then I or someone else
enters the same serial number in the spreadsheet. I need the validation or
filter to avoid double data.

Peo Sjoblom

filter or validate to avoid repeated data
 
http://www.cpearson.com/excel/NoDupEntry.aspx



--
Regards,

Peo Sjoblom




"Fabricio Recalde" <Fabricio wrote in
message ...
If you are entering data such as serial numbers and then I or someone else
enters the same serial number in the spreadsheet. I need the validation or
filter to avoid double data.





All times are GMT +1. The time now is 04:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com