Forum Discussion
Excel Number duplication help
I have a excel spreadsheet ( 2008) that I need to keep one column from duplicating- the field is usually filled with numeric codes similar to this 20194567 but would all have very close numbers 20194...
Hi,
You can catch and prevent duplicates as you enter the data using Data Validation, please see this https://www.youtube.com/watch?v=pkppGc4FhVU to learn more.
Regards
sorry its 2010 softwear