Sep 16 2019 08:44 AM
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 20194568, 20194570 etc is there away to make sure that 20194567 is not duplicated and a error message
Sep 16 2019 09:25 AM
Hi,
You can catch and prevent duplicates as you enter the data using Data Validation, please see this video to learn more.
Regards
Sep 16 2019 10:47 AM
Sep 16 2019 11:45 AM
The version of Excel in the video is 2010 as well!
If you're working on Mac, I guess that you have Excel 2011!
If so, please see this video to learn the Data Validation basics.
The steps are almost the same and the Data Validation window not much different.