Stop Entry of Duplicate Values in Excel
How to stop Duplicate Entry in Excel. It is possible to stop duplicate entries in excel with a simple solution, many a times we have to waste a lot of time in removing duplicate values from excel files or excel sheets now in this excel tutorial you learn how with the help of data validation and countif formula you can stop duplicate entries being done in excel.
The process to stop duplicate entries in excel is
1. Select the range in which you want to restrict duplicate entries
2. Click on Data Tab
3. Go to Data Validation
4. Select Custom from the options
5. Use the Countif formula as shown in the video to stop the entry of duplicate values
You can download the file from this link http://wp.me/p7DKaP-1h4
** Useful Excel formulas and Functions **
10 Most Used Formulas MS Excel- • 10 Most Used Formulas MS Excel
Learn Basic Excel Skills For Beginners- • Learn Basic Excel Skills For Beginner...
Learn the Basic of Excel for Beginners - • Learn the Basic of Excel for Beginner...
10 Most Used Excel Formula- • 10 Most Used Excel Formula ☑️
Learn Vlookup Formula For Beginners in Excel- • Learn Vlookup Formula For Beginners i...
5 Excel Questions Asked in Job Interviews- • 5 Excel Questions Asked in Job Interv...
Create Speedometer Chart In Excel- • Create Speedometer Chart In Excel
Create Pareto Chart In Excel- • Create Pareto Chart In Excel
How to Create Dashboard in Excel- • How to Create Dashboard in Excel ☑️
Excel Interview Questions & Answers- • Excel Interview Questions & Answers ☑️
To watch more videos and download the files visit http://www.myelesson.org
To Buy The Full Excel Course visit . http://www.myelesson.org/product or call 9752003788
Connect with us on Facebook - / excelmadeasy
Connect with us on Twitter - / excelmadeasy
Watch video Stop Entry of Duplicate Values in Excel online without registration, duration hours minute second in high quality. This video was added by user My E-Lesson 16 August 2019, don't forget to share it with your friends and acquaintances, it has been viewed on our site 2,634 once and liked it 134 people.