Basic steps for Excel to prompt for duplicate items

Time: 2022-02-16Source: Huajun Software TutorialAuthor: Ai Xiaomo

Many friends like to use Excel for office work, but some friends still don’t understand the basic steps of Excel prompting duplicate items, so here the author has shared a tutorial on Excel prompting duplicate items, let’s take a look.

​ ​Select the range of the table to be set. Click [Data Validation] in the [Data] tab above. The higher version is called [Data Validation].

​​Set the permission inside to [Custom], and then enter =COUNTIF(A:A,A1)=1 in [Formula], which means starting from column A, starting from A1, all content can only appear once.

              Set the prompts given when data is duplicated in the error warning.

After clicking OK, the system will automatically give you a prompt next time you enter repeated content in the data column.

The above explains the basic steps of how to prompt duplicate items in Excel. I hope friends in need can learn it.

Related articles更多>>

• Graphical tutorial on converting negative numbers into positive numbers in batches in Excel
• Specific instructions for copying formulas in Excel
• Excel table prompts to solve the problem when sending commands to the program
• Tips for solving incorrect values ​​when using the VLOOKUP function in Excel
• An explanation of how to clone a table in Excel
• Detailed instructions on how to automatically fill in working days in Excel
• Tutorial on how to reverse text in Excel
• Graphical step-by-step description of splitting addresses in Excel
• Detailed explanation of how to use the column function in Excel
• Google Chrome downloads graphic and text operation content of web videos

Popular recommendations

• 

  7Zip Chinese version for Mac

  Version: latest versionSize: 1.76 MB

  7Zip Chinese version Mac official version is a compression and decompression tool suitable for use on the Mac platform. The latest version of 7Zip Chinese version for Mac supports 7z, Rar, Tar, B...

• 

  Bandizip

  Version: 7.31Size: 34.8MB

  Bandizip The official Mac version is a powerful Mac online compression and decompression tool. The latest version of Bandizip has a variety of convenient functions and is suitable for Mac...

• 

  Sogou input method Mac version

  Version: 6.15.2Size: 140.85MB

  The Mac version of Sogou Input Method inherits the super word grouping algorithm of PC Sogou Pinyin Input Method. It has a large vocabulary, fast typing, and smooth hand feel. Mac Sogou Input Method can also be used directly...

• 

  Sogou Wubi input method for Mac

  Version: 1.4.0 latest versionSize: 41.86 MB

  The latest version of Sogou Wubi Input Method for Mac is a Wubi input tool created by Sogou for users. The official version of Sogou Wubi input method for Mac uses Wubi + Pinyin...

• 

  Sogou Wubi

  Version: v1.4.0Size: 41.86 MB

  Sogou Wubi official version is a Wubi input tool created by Sogou for users. The official version of Sogou Wubi can not only input pure Wubi, but also pinyin...