» Preventing Duplicates While Entering Data in Excel 2007
CATEGORY - Excel Editing
VERSION - Microsoft Excel 2007
To prevent duplicates while entering data:1. Select a range of cells, for example, A2:A20.
2. Select Data -> Data Validation (in Data Tools Group).
3. In Data Validation dialog box, select Settings -> Allow -> Custom.
4. In the Formula box, enter the following formula:
=COUNTIF($A$2:$A$20,A2)=1
5. Select the Error Alert tab.
6. In the Title box, enter: Duplicate Entry.
7. In the Error message box, enter: The value you entered already appears in the list above.
8. Click OK.
Book Store:
Recommended Books:
- Wall Street Journal Guide to Understanding Money and Investing
- The Guide to Understanding Financial Statements
- Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002
- Microsoft Office XP Introductory Concepts and Techniques
- Infectious Greed: How Deceit and Risk Corrupted the Financial Markets
- The One Page Business Plan: Start With a Vision, Build a Company!
No comments have been submitted.
