Restrict users from entering duplicate entries in Excel

Build, using data validation in Excel, an Excel tool that will, firstly check where a new number or text has already been used, and secondly is a duplicate, but more importantly will also restrict the user from entering a text or number that is a duplicate.

------------------------------------------------------------------------------------------------------------------------------------------------------

✅- Free check of your Excel Skill Level- https://excel-skills-assessment.com/s...
🏅- Test employee Excel skill levels- https://excel-skills-assessment.com/e...
🏆- Improve you Excel Skill Levels- https://online-excel-training.auditex...
🇿🇦- Our main website- https://www.auditexcel.co.za/blogs/

------------------------------------------------------------------------------------------------------------------------------------------------------
⏲Time Stamps
00:00 Stop users from entering duplicate transactions in Excel
00:16 Check if the text or number already exists in the Excel list previously
01:34 Stop the users from entering a text or number that already exists (advanced data validation)