Home

Excel Number duplication help

%3CLINGO-SUB%20id%3D%22lingo-sub-857321%22%20slang%3D%22en-US%22%3EExcel%20Number%20duplication%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-857321%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20excel%20spreadsheet%20(%202008)%20that%20I%20need%20to%20keep%20one%20column%20from%20duplicating-%20the%20field%20is%20usually%20filled%20with%20numeric%20codes%20similar%20to%20this%2020194567%20but%20would%20all%20have%20very%20close%20numbers%2020194568%2C%2020194570%20etc%20is%20there%20away%20to%20make%20sure%20that%2020194567%20is%20not%20duplicated%20and%20a%20error%20message%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-857321%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%202008%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-857379%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Number%20duplication%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-857379%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F409593%22%20target%3D%22_blank%22%3E%40Admin20192205%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20catch%20and%20prevent%20duplicates%20as%20you%20enter%20the%20data%20using%20Data%20Validation%2C%20please%20see%20this%20%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DpkppGc4FhVU%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Evideo%3C%2FA%3E%20to%20learn%20more.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-857540%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Number%20duplication%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-857540%22%20slang%3D%22en-US%22%3EThanks%20but%20the%20Data%20Validation%20window%20is%20different%20on%20this%20version%20and%20so%20not%20sure%20if%20i%20can%20do%20the%20same%20steps!%20apparently%20we%20have%202008.%20any%20clues%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-857546%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Number%20duplication%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-857546%22%20slang%3D%22en-US%22%3Esorry%20its%202010%20softwear%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-857635%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Number%20duplication%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-857635%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F409593%22%20target%3D%22_blank%22%3E%40Admin20192205%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20version%20of%20Excel%20in%20the%20video%20is%202010%20as%20well!%3C%2FP%3E%3CP%3EIf%20you're%20working%20on%20Mac%2C%20I%20guess%20that%20you%20have%20Excel%202011!%3C%2FP%3E%3CP%3EIf%20so%2C%20please%20see%20this%20%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DMjE6z83XM4A%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Evideo%3C%2FA%3E%20to%20learn%20the%20Data%20Validation%20basics.%3C%2FP%3E%3CP%3EThe%20steps%20are%20almost%20the%20same%20and%20the%20Data%20Validation%20window%20%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%3Enot%20much%20different.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Admin20192205
New Contributor

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 

4 Replies

@Admin20192205

 

Hi,

 

You can catch and prevent duplicates as you enter the data using Data Validation, please see this video to learn more.

 

Regards

Thanks but the Data Validation window is different on this version and so not sure if i can do the same steps! apparently we have 2008. any clues?
sorry its 2010 softwear

@Admin20192205

 

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.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies