Office software is closely linked to the PDF,the PDF is also must have to control!
Set home Page Add to Favorites
|
to solve the problem in this article: EXCEL in how to prevent data duplication? How to achieve the alarm to repeat the data? EXCEL data how to do repetitive testing?
sometimes we need to input a large amount of data in Excel and not allowed to repeat, such as ID cards, telephone numbers and so on. Can Excel automatically issued on repeated warnings, according to information, timely to remind them?
First of all open Excel 2003 worksheet, click Select All button on the top left corner is the upper-left corner of the A1 format.
Step 1 from the "Data" menu choice under the "validity" from "allow" drop-down list box, select "Custom" and then in the "formula" the text box below entered manually
"= COUNTIF ($ 1: $ 65535, A1) = 1"
here "$1: $65,535," said the scope of the entire worksheet for repeat inspection.
 If you need to check only a specific range of cells, according to the actual situation can be re-adjusted, but must use an absolute way.
|
