Ways to set non-repeatable input in WPS type.txt

In daily life and work, we typically make use of the WPS form to create some data components, a number of which have particular special qualities, for example student ID, employee quantity, ID number, etc., these data have the qualities of non-repeatability , So we will have to pay special focus when entering manually. Is there a technique to set it up inside the table so that we cannot enter duplicate products? Certainly there is! Here, testdisk recover partition table on the Word Alliance will share with you tips on how to set the input in the WPS form to become non-repeatable.

① Choose the relevant cell range beneath the student number, click the 'Data' tab, and choose the 'Validity' command.

②In the pop-up information validity dialog box, click the drop-down triangle for the ideal of “Allow” and select “Custom”.

③ Within the dialog box under the formula, enter '=countif(A:A,A2)=1'. ( recover hdd partition table :A indicates to judge all of the cells in column A, A2 is always to judge the chosen cell, equal to 1 implies the uniqueness with the chosen cell, the entire function expresses the which means of just about every learning inside the whole region Quantity is set to exclusive).

④ Switch to the 'Error Warning' tab, click the drop-down triangle for the suitable of 'Style', pick a technique you want inside the pop-up drop-down list, we choose 'Stop' and after that enter 'Error' inside the dialog box below the title 'Warning', 'Error Information', enter the corresponding text, enter 'enter student number error, please re-enter', and lastly click 'OK' to complete.

⑤ At this time, only the non-duplicate things could be entered inside the chosen cell range. When accidentally getting into a duplicate item, an “error warning” will automatically pop as much as remind.