Excel表格中如何设置能阻挡和幸免重复内容的输进(国外英语资料).doc

Excel表格中怎样设置能阻止和防止重复内容的输入 How does the Excel table set prevent repetition (how do you avoid duplication of data in the Excel table?) How to use data validity to limit the input of data in Excel worksheets. When data is entered in Excel, it is sometimes required that the cell data in a particular column or region be unique, such as id number, invoice number, and so on. But what we do when we input is that the data is the same and the data is the same, and its hard to find, right? Data validity? To prevent duplicate input. One, the whole column sets not repetition method: Method 1, select the column, such as column A Menu: data - effectiveness - Settings TAB in the dialog box allow choose custom under the formula , input = COUNTIF (A $1: A1, A1) = 1 can or determine Method 2, select this column area (for example, select A column) Menu - data - data validity allows you to select the formula in the formula below: = COUNTIF (A, A1) = 1. (please note that the half Angle symbol is used, and the spelling and case of the function are not wrong.) To select A customization place, enter at the formula: = COUNTIF (A, A2) 2 or = COUNTIF (A $1: A1, A1) = 1 or = COUNTIF (A: A, A1) = 1 After setting the same column in the same column, call the police, as shown below ? 2, a certain area is set not to repeat: If you do not need an entire column setting, you can select a contiguous column area and set it up, as shown in the figure blue area Select C3: C20 area, data-data validity Allow customization Formula for = COUNTIF ($C $3: $C $20, C3) = 1 Example: the employees id number should be unique. To prevent duplicate input, we use data validity to prompt you. Select the cell area (such as D3 to D14 column) that needs to be set up to enter the id number, and execute data to be valid The sex command, open the data validity dialog box, under Settings TAB, press allow the drop-down button on the right, In the shortcut menu that pops up, select the customize option and then enter the for