Prevent Duplicate Values in a Range in Excel

[@IvanCortinas_ES]

A good explanation. Thank you!!!

[@kittypie2011]

Good information..I wanted to avoid duplicate words within a row cell. In that case , can we apply this one.Can u plz explain?

[@edmunlum]

Thanks for this guide, very useful.

[@caitididnt]

Looking to host speed dating events in my area, because online dating apps (blech). I'm getting closer and closer to understanding how to write a formula that would prevent participants from meeting again at future events. If Jenny S. and Ben K. met at Event #1, I would like a formula that would alert me if they both happen to sign up for Event #2 (think large scale, lots of participants to keep track of). This video got me one step closer (thank you). If anyone has tips or tools to lead me in the right direction or formulas I should check out, please let me know! Thanks in advance!

[@darrylmorgan]

Nice Tutorial Thank You Sir

[@TeachExcel]

You're very welcome)

[@lazyreviewssupport9811]

supposing values in two or more cols make up the uniqueness how to use this or is there an alternative to check a *record already exists?* 😶😶

[@nahlas.3836]

Awesome!!!!!!!!!

[@FRANKWHITE1996]

Nice! Thx! 🙌

[@ANKITSINGH-sr2bk]

But if u Copy paste the value it will not work

[@TeachExcel]

Data Validation rules are overwritten/removed on copy/paste, so, if you are doing that, you need to clean the data after importing/copying it.

[@ANKITSINGH-sr2bk]

@@TeachExcel and how to clean the data

[@TeachExcel]

@@ANKITSINGH-sr2bk Here is one of my videos that shows you how to clean data: kzbin.info/www/bejne/n3SaapVrfdKDo8U